Stacked Col Chart : Legends not working as expected with field parameters

[rithu]

Hello, 

I have a Stacked Column chart, Where x is type of subject and y is a field parameter with measures - attendence percentage and absent percentage. In the legends, I want to reasons why they were absent (sick, permission grated, no permission, attended, leave). 

When I add the legends with the measures. All the legends are set 100% and the actual % for various reasons don't show up. Where could it have gone wrong?

Can you help?

Table 

Subjects - English, Maths, Science, Social

attendence percentage measure - DIVIDE(countrows(ATTENDED),countrows(allvalues))

Reasons - sick, permission grated, no permission, attended, leave

Thanks

[amitchandak · Accepted solution]

@rithu , You have create a measure like

 DIVIDE(countrows(filter( Table, Table[reasons]= "ATTENDED") ) ,calculate(countrows(Table, removefilters(Table[reasons] ) ) ) )

or

DIVIDE(countrows(Table) ,calculate(countrows(Table, removefilters(Table[reasons] ) ) ) )