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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

Is there anything else we can help with regarding this thread?

Best Regards

Rena

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Nah I think it's all sorted. Thanks