Forum Discussion

odada11's avatar
odada11
Helper I
3 years ago

undefined

Hello All,

 

pls i have this table

i will like to calculate Percentage of all, i want my total Conflict to show as 100% and The Crisi TM a percentage of the Total Conflict, While Unresolved Tm a percentage of the Total conflict.
Below is what i want to achieve;

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    odada11 , if Total Conflict  is measure

    create new measures by diving then to  Total Conflict

     

    divide([Total Conflict], [Total Conflict]) 

     

    It this a row value

     

    divide([Total Conflict], calculate([Total Conflict], filter(allselected(Table), Table[Type]= "Conflict") ))

     

    or

     

    divide([Total Conflict], calculate([Total Conflict], Table[Type]= "Conflict") )