Category Percentage of Row Total

[Lukaszj]

Hello, I have data similar to the sample set pictured above - I am trying to calculate the percentage of each individuals Win/Loss value relative to their own total.

If I choose to display the contract amount as a percentage of row total, they all just show as 100%. Ideally I would like, for example, to see that Mike's "Lost %" is (463/497)*100 or 93.2% of his personal total, and Wins as 6.8%. I have been able to calculate each line item as a percentage of the GRAND total, but not as a percentage of each individuals total. (i.e. 463/335,981)

Thank you!

Lukasz

[FrankAT · Accepted solution]

Hi @Lukaszj ,

use the following measure:

Percentage = DIVIDE(SUM('Table'[Value]),CALCULATE([Sum of Value], ALLSELECTED('Table'[Contract])))

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)