Row Total By two Categories

[dudasucx]

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.

Thanks in advance

[Ashish_Mathur]

Hi,

Are Current and Past Due measures?  Share the link from where i can download your PBI file.

[dudasucx]

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

[CheenuSing · Accepted solution]

Hi @dudasucx 

Please check th link

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

Cheers

CheenuSing

[dudasucx]

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!!