Percentages by Legend in Clustered Bar Chart

[Raudolph11]

Hi All,

I'm transitioning from Tableau to PowerBI and I'm trying to compare two testing sessions (TermNames) by percentages at each quintile level (Low, LoAvg, Avg, HiAvg, High). It works fine in the bottom right Matrix table. But, I can only get the Count of Student ID to show in the clustered column chart. When I try to change the Y-axis from Count of Student ID to Show value as...it only gives me the option to use percent of grand total...not percent by TermName.

Any help would be greatly appreciated!

[amitchandak]

@Raudolph11 , You can create by creating a measure

divide(count(Table[Student ID]), calculate(count(Table[Student ID]), removefilters(Table[TermNames]) ))

or

divide(count(Table[Student ID]), calculate(count(Table[Student ID]), allselected(Table[TermNames]) ))

refer: https://www.youtube.com/watch?v=6jTildcV2ho

[Raudolph11]

I'm not sure where to put the new measure in the clustered column chart.  I tried putting it in the Y-axis, but it gives me 100% for each quintile.