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
I think i know why it's not giving me the answer it should be....i think the divide formula is also including the '99s' as part of the total, which I want to exclude from the overall calculation
Percent 5-7 Educate Employees =
DIVIDE([Count of 5-7 Educate Employees],COUNT('Report 1'[Educate employees])
is what I have currently...
Hi Anonymous ,
Is there anything else we can help with regarding this thread?
Best Regards
Rena
Nah I think it's all sorted. Thanks