cancel
Showing results for
Did you mean:
Regular Visitor

## Row Total By two Categories

Hello I have a dataser similar to:

 East West Total CLIENT 1 130 150 280 % of Total Current 120 16% 139 16% 259 16% Past Due 10 1% 12 1% 22 1% CLIENT 2 108 125 233 Current 100 13% 116 13% 216 13% Past Due 8 1% 9 1% 17 1% CLIENT 3 58 67 125 Current 50 7% 58 7% 108 7% Past Due 8 1% 9 1% 17 1% CLIENT 4 455 526 981 Current 450 60% 520 60% 970 60% Past Due 5 1% 6 1% 11 1% TOTAL 751 100% 868 100% 1619 100%

As you can see when I add the column Sales Again, and then format it to show as total of column, it gives me the percentage of the whole Division East, West. Not for each client.

What I need to have is:

 East West Total CLIENT 1 130 150 280 % of Total Current 120 92% 139 92% 259 92% Past Due 10 8% 12 8% 22 8% CLIENT 2 108 125 233 Current 100 93% 116 93% 216 93% Past Due 8 7% 9 7% 17 7% CLIENT 3 58 67 125 Current 50 86% 58 86% 108 86% Past Due 8 14% 9 14% 17 14% CLIENT 4 455 526 981 Current 450 99% 520 99% 970 99% Past Due 5 1% 6 1% 11 1%

I tried doing a formula like this:

Total Per Client = CALCULATE(SUM('Clientes'[Invoices]),ALLEXCEPT('Clientes','Clientes'[CLIENT]))

But this formula gives me a table like this:
 East West Total CLIENT 1 280 280 280 Current 280 280 280 Past Due 280 280 280 CLIENT 2 233 233 233 Current 233 233 233 Past Due 233 233 233 CLIENT 3 125 125 125 Current 125 125 125 Past Due 125 125 125 CLIENT 4 981 981 981 Current 981 981 981 Past Due 981 981 981

The question is:

How can I make a Total By Client and By region, So then I can make a Divide of the total by this new measure to obtain the % of each client by region.

1 ACCEPTED SOLUTION
Community Champion

Solved: Category Percentage of Row Total - Microsoft Power BI Community

Cheers

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
4 REPLIES 4
Super User

Hi,

Regards,
Ashish Mathur
http://www.ashishmathur.com
Regular Visitor

There is only one measure, there is no time intelligence involved here. I wll create a sample file to share.

Community Champion

Solved: Category Percentage of Row Total - Microsoft Power BI Community

Cheers

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Regular Visitor

I0ve already seen that post of yours, and tried it, but I was assigning a wrong variable to the AllExcept. Seeing it again gave me new light!! Thanks KUDOS!!

Announcements