Hi,

I am trying to calculate the percentages of attendance (binary column 1 =attended 0 =not attended) for 10 different modules in Power BI. The format of the columns is below:

Module 1	Module 2	Module 3	Module 4 etc.
1	0	1	1
1	1	0	1
0	1	0	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?