% of Total

[Anonymous]

Hey PBI Community, 

Trying to do this coverage analysis, I want to show this certain leaders coverage across all sales contients where its a breakdown of his number of total seats where the percentages should total 100%....I got close where I was able to show this certain leaders breakdown of his % seats, what I got was a correct %, this leader owns 53% of all total seats and what my chart is showing is a breakdown of his 53% but essentially I want the 53% number to be 100% so I think i need to change the target variable to reflect sales contient and make a subset of that? 

[Anonymous · Accepted solution]

Hi @Anonymous ,

How do you get 100% for the total? It doesn't seem possible to get 100% by calculation based on the data you've shown.

If you just want the total show 100%, you could modify the formula as below:

coverage = 
var a = ...

var b = ...

var c = a/b

var _row = ISINSCOPE(row in matrix)

var _column = ISINSCOPE(column in matrix)

return

IF(NOT(_row)&&NOT(_column),1,a/b)

It will always return 100% instead of 53% in the total.

Best Regards,

Jay

[SteveHailey]

For your target variable, try:

VAR target =
CALCULATE (
    SUM ( 'IRR Retina'[Total Seats Denominator] ),
    FILTER ( ALL ( 'IRR Retina' ), 'IRR Retina'[Leader] = "Thiago Coutinho" )
)