Hello I have a dataser similar to: East West Total CLIENT 1130 150 280% of TotalCurrent12016%13916%25916%Past Due101%121%221%CLIENT 2108 125 233 Current10013%11613%21613%Past Due81%91%171%CLIENT 358 67 125 Current507%587%1087%Past Due81%91%171%CLIENT 4455 526 981 Current45060%52060%97060%Past Due51%61%111% TOTAL751100%868100%1619100% 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 1130 150 280% of TotalCurrent12092%13992%25992%Past Due108%128%228%CLIENT 2108 125 233 Current10093%11693%21693%Past Due87%97%177%CLIENT 358 67 125 Current5086%5886%10886%Past Due814%914%1714%CLIENT 4455 526 981 Current45099%52099%97099%Past Due51%61%111%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: EastWestTotalCLIENT 1280280280Current280280280Past Due280280280CLIENT 2233233233Current233233233Past Due233233233CLIENT 3125125125Current125125125Past Due125125125CLIENT 4981981981Current981981981Past Due981981981 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

Hi Anonymous Please check th linkSolved: Category Percentage of Row Total - Microsoft Power BI Community CheersCheenuSing

Anonymous

Not applicable

4 years ago

Solved

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.

Thanks in advance

Need Help

Anonymous
4 years ago
Hi Anonymous

Please check th link
Solved: Category Percentage of Row Total - Microsoft Power BI Community

Cheers

CheenuSing

Forum Discussion

Row Total By two Categories

4 Replies

Related content

DAX total != total rows

custom total row

Getting Totals On Each Row

Cumulative total by category

Total Row counts by category