Percentage of students with score above 60% in each course

[bammyd]

Hello,

Please see the table below. I want to calculate the percentage of students with scores >= 60 for each subject or just 1 subject. I want to be able to display this percentage on a scorecard. 

Students	Course	Score
A1	math	55
A1	english	61
A1	french	70
B2	english	90
B2	math	85
B2	english	60
C3	french	72
C3	english	95
C3	math	90
D4	french	55
D4	english	70
D4	french	65

[Ashish_Mathur]

Hi,

Please show the expected result very clearly.

[parry2k]

@bammyd here is the measure, I wanted to check if that is the output/calculation you are looking for:

Above 60 % = 
VAR __above60 = CALCULATE ( DISTINCTCOUNT ( 'Table'[Students] ), 'Table'[Score] >= 60 )
VAR __total = CALCULATE ( DISTINCTCOUNT ( 'Table'[Students] ), ALL ( ) )
RETURN
DIVIDE ( __above60, __total )

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[parry2k]

@bammyd is this what you are looking for?

[bammyd]

@Ashish_Mathur This is the result I want but I can't quite figure out what measure to use.

[Ashish_Mathur]

Hi,

To your matrix, drag Course to the rows section.  Write these measures

Student count = distinctcount(data[students])

Measure = divide(calculate([Student count],score>=60),[Student count])

Hope this helps.

[bammyd]

Hello parry2k ,

Yes, this is what I want but I don't see any measures to calculate it.