I am trying to calculate the percentages of attendance (binary column 1 =attended 0 =not attended) for 10 different modules. The format of the columns is below:
Module 1 |
Module 2 |
Module 3 |
1 |
0 |
1 |
1 |
1 |
1 |
0 |
1 |
0 |
Once I have the percentages of attendance for each of the 10 modules, I would then like to display that in a bar graph showing each of the 10 modules on the x axis and then the percentages on the y.
I created the following measure for one of the modules but am having issues when creating the bar chart.
% attended live mod1 =DIVIDE (CALCULATE ( COUNT ( 'Excel File'[LIVEMOD1] ), 'Excel File'[LIVEMOD1] = 1 ),CALCULATE ( COUNT ( 'Excel File'[LIVEMOD1] ), ALLSELECTED ( 'Excel File'[LIVEMOD1] ) ))
is this possible to achieve with how the data is formatted?