I am trying to 1) 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 ||Module 4 etc. |
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 =
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?