Forum Discussion

rithu's avatar
rithu
Frequent Visitor
3 years ago
Solved

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

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 the...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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] ) ) ) )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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] ) ) ) )