Forum Discussion
Counting values per column
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?
Start by unpivoting your data
after than you can do a count of the completed and divide i with the total
4 Replies
Do you have the option to unpivot your data in power query?
Start by unpivoting your data
after than you can do a count of the completed and divide i with the total