Show percentage of total by levels

[natureorigin01]

Hi,

I have found a way to compute the percentage of each Status under each Source, but now the percentage of each Source is 100%,

I need it to be the percentage of the column total, please advise if you can, thank you!

[v-diye-msft]

Hi @natureorigin01 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!

[ryan_mayu]

@natureorigin01 

Is this what you want?

Measure = 
VAR amount= sum('Table'[value])
VAR total = CALCULATE(sum('Table'[value]),ALLEXCEPT('Table','Table'[Type]))
return amount/total

Measure 2 = 
VAR amount= sum('Table'[value])
VAR total = CALCULATE(sum('Table'[value]),ALL('Table'))
return amount/total

[natureorigin01]

Hi,

Thanks for your reply,

I want something like this, only 1 column for percentage, not 2.

The percentage for each source row should be the total lead count / column total (5% for TER as 42/792)

and the percentage for each status under each source should be the total lead count of the status / total lead count of the source (33% for approved under TER as 14/42)

[ryan_mayu]

@natureorigin01 

I have updated the DAX. Please have a try.

Measure 2 = 
VAR amount= sum('Table'[value])
VAR total = CALCULATE(sum('Table'[value]),ALL('Table'))
var total2 = CALCULATE(sum('Table'[value]),ALLEXCEPT('Table','Table'[Type]))
return if(ISFILTERED('Table'[subtype]),amount/total2,amount/total)