Showing how many learners got each achievement on courses

[Anonymous]

Hi, 

I'm new to power BI and am struggling creating the table I want from the data for work.

The dataset is in the following structure and shows what achievement each learner (LearnerID) got in the courses they did.

LearnerID	Course	Achievement
1	Maths	Passed
1	English	Distinction
1	Science	Failed
2	Maths	Failed
2	English	Passed

And so on. 

And I want my table on the dashboard to look like this to show how many learners got each achievement for each course. E.g. in maths 5 learners got distinction, 17 passed and 4 failed.

Course	Distinction	Passed	Failed
Maths	5	17	4
English	11	13	6
Science	2	21	5

Any help would be greatley appreciated.

Thanks

[Mikelytics · Accepted solution]

Hi @Anonymous 

Base Table

Please create the following Measure

Distinct Learner ID = 
DISTINCTCOUNT(LearnerTable[LearnerID])

Put the fields into a martrix visual

Depending on your requirements it could also be better to use the following measure instead of the distinct measure.

CountRows = 
COUNTROWS(LearnerTable)

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn