Power BI - count number of rows based on filter in one row

Question

I'm trying to count rows based on filter in row called flag. I want to count only rows where flag is 1 or 2 and put that in variable since I'll need it for further calculation.

Sample data:

I have something like this so far but it's not working:

var average = CALCULATE(COUNTA(FILTER(table;[flag] = 1 && [flag] = 2)))

Ivo · Accepted Answer · 2019-10-09 08:25:04Z

1

In the COUNTA function, you first must write the column you want to count. After, you apply the filter to the CALCULATE function (you don’t need the filter statement here):

var average = CALCULATE(COUNTA(table;[flag]); table[flag] = 1 && table[flag] = 2)

answered Oct 9, 2019 at 8:25

Ivo

3071 gold badge4 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Hrvoje Over a year ago

Problem is && its implying both conditions have to be met. How do I put OR there?

Ivo Over a year ago

Use || instead of &&

Hrvoje · Accepted Answer · 2019-10-09 08:40:09Z

0

It worked with:

COUNTROWS(FILTER(table;[flag] == 1 || [flag] == 2))

thank you @Ivo for the tip about ||. I didn't manage to make it work with CALCULATE.

answered Oct 9, 2019 at 8:40

Hrvoje

15.4k11 gold badges103 silver badges121 bronze badges

Collectives™ on Stack Overflow

Power BI - count number of rows based on filter in one row

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related