Counting values per column

[Anonymous]

Hi, here a question that I thought should be very simple. But after searching for a while on this forum and trying it myself I haven't found an answer yet. Maybe I'm overlooking a simple solution.

I have several extensive tables with data about students completing a multi-chapter course. The structure greatly simplified:

What I would like to achieve with Power BI:

• computation per chapter: the percentage of students who have completed that particular chapter (in this example: 80% 60% 60% 40% 40%)
• a visualization of these percentages as a bar chart (so 5 bars in this example)

Anyone any idea?

[NickolajJessen · Accepted solution]

Start by unpivoting your data

after than you can do a count of the completed and divide i with the total 

[Anonymous]

Thanks! Succeeded with a grouped column chart:

[NickolajJessen]

Do you have the option to unpivot your data in power query?

[Anonymous]

Never used unpivot in Power BI before, but I looked up some documentation about this option and see the point of transforming this table to a more usable form. I am going to work on this.