New to Power BI today so apologies if this is very basic.
I am trying to calculate the percentage of grades in Maths column that are 5 or above.
I have added a new measure for this but believe there is no countif function?
Go to Solution.
You can create a calculated column
grade = IF(yourTable[value]>=5,"5 or above","less than 5")
And then create a measure
perc above 5 = COUNTROWS(FILTER(yourTable,yourTable[value]>=5))/COUNTROWS(ALL(yourTable))
See more details in the attached pbix file. If you'd like more specific suggestion on your scenario, please post some sample data and expected output.
View solution in original post
I would also like to be able to view the records of who has that grade.
Hi, I am struggling with something very similar and hope you may be able to help. I want to present the percentage of calls answered within 20s as a gauge byt cant figure out the measure.
Any guidance would be great.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.