Percentage Calculation of two Categories

[kolturra]

Hi,

I have data like below sample one, i am trying to achieve % of each customer with each Age of product with total MPR value of Customer. Below is the data in my power bi table. Can some one please help me understand what kind of DAX i have to use or quick measure.

This is how i want to see 

 
Thanks,

K Raghavender Rao

[Interkoubess]

Hi @kolturra,

Please check this formula ( my table is called Table1). For the grand Total it won't work but the rest :

% of client each aging = var SumA=CALCULATE(SUM(Table1[MPR]),FILTER(ALL(Table1),Table1[Customer]="A")) var SumB=CALCULATE(SUM(Table1[MPR]),FILTER(ALL(Table1),Table1[Customer]="B")) return IF(SELECTEDVALUE(Table1[Customer])="A",DIVIDE(CALCULATE(SUM(Table1[MPR])),SumA,0),DIVIDE(CALCULATE(SUM(Table1[MPR])),SumB,0))

Hope it helps....

Ninter

[kolturra]

Hi @Interkoubess,

Thanks for your reply.

Table which i have provided is sample i have around 10,000 records like that in customer column and all have different customer names, can you please help me how should i handle it.

Thanks,

K Raghavender Rao

[v-chuncz-msft · Accepted solution]

@kolturra,

You may refer to the following post.

http://community.powerbi.com/t5/Desktop/Subtotal-Percentages/m-p/313658#M139139