Forum Discussion
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...
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
Not entirely sure what you mean, but since i'm searching for help myself, i figured maybe i can assist in this.
Have you tried something like:
Calculate(count(ID);[result] >= 5 && result <=7)?
I don't think I understand your response, but I'm unable to make that work...
Can you give me / us a rough sketch of how your table looks?
Can be fictious data.
Educate employees 4 99 7 5 7 7 7 6 7