Forum Discussion
Measure to count people scoring below 50 %
Hi, I want a solution for the following scenario. I have a table with names and percentages. I want a power query to count the people who have scored 70% to 80% Thank you Power query ...
Hi Snehal_123
We can create a measure to count number of peple scoring below the required condition.
the syntax would be like:
Measure= CALCULATE(COUNT(TABLE'PERCENTAGE'), FILTER(TABLE, TABLE(PERCENTAGE)<50%))