Right now I have a set of data in PowerBI as shown in the screenshot above. I have a Measure to calculate the % of OK:
total_student = COUNT(StudentAns[Name])
VAR OK_COUNT = COUNTROWS(
StudentAns[Answer] = "OK"
I created a Matrix to show the % of OK for each month as shown in the screenshot below:
The average percentage for all of the months is what I'm looking for. As a result, the final output response should be 89.05 percent, which is calculated as the average of 85.95 percent, 91.4 percent, 89.27 percent, and 89.58 percent.
Because I want to use the result as a Target Goals for KPI visualisation, I want to get the average % of OK throughout all of the months.