Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate Count formula

Hello   Power BI novice user here. I'm trying to use the calculate(count...) formula to work out the total number of results that are >=5 and <=7 (i.e. all 5's, 6's, 7's). The dataset has '99' as a...
Need Help
Show and Tell
  • decarsul's avatar
    decarsul
    5 years ago

    CALCULATE(COUNT('Report1'[Educate employees]),'Report1'[Educate employees]>=5 && 'Report1'[Educate employees]<=7)

     

    the && functions as an AND when turning to SQL, which means the filter has to pass BOTH criteria

decarsul's avatar
decarsul
Icon for Helper V rankHelper V
5 years ago

CALCULATE(COUNT('Report1'[Educate employees]),'Report1'[Educate employees]>=5 && 'Report1'[Educate employees]<=7)

 

the && functions as an AND when turning to SQL, which means the filter has to pass BOTH criteria

decarsul's avatar
decarsul
Icon for Helper V rankHelper V
5 years ago

Can create a seperate column and do a sum on that.

=IF(AND('Report1'[Educate employees] >= 5;'Report1'[Educate employees] <= 7);1;0)

 

This will return a value of 1 when its between 5 and 7, and value of 0 when its not, and will do this on each row.

Then you can just SUM() the new column