Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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] ) ) ) )
@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] ) ) ) )
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |