topic Total of a column based on condition of another column in DAX Commands and Tips

Total of a column based on condition of another column

SteT82 — Tue, 22 Aug 2023 13:07:22 GMT

Hallo

I have a table like this

CUSTOMER	TYPE	SALES
A	prio	10
B	normal	5
C	low	4
D	prio	3

And I would like 1. to get a Dax function giving me the total of the sales of all the priority customers 2. only for the priority customers getting the percentage of its sales over the total of the prio sales

See ideal result:

CUSTOMER	TYPE	SALES	TOT PRIO SALES	% on tot prio sales
A	prio	10	13	77%
B	normal	5	13
C	low	4	13
D	prio	3	13	23%

Thanks!

Re: Total of a column based on condition of another column

JoeBarry — Tue, 22 Aug 2023 13:20:00 GMT

Hi SteT82

1st measure is to Create Priority Sales

Total Priorty Sales = CALCULATE( SUM(test[SALES]), KEEPFILTERS(test[TYPE] = "prio"))

2nd measure is to create a Total Priorty Sales

Prio Sales = CALCULATE([Total Priorty Sales], ALL(test))

3rd Create % of Total

Tot Prio sales% = DIVIDE([Total Priorty Sales], [Prio Sales])

Convert the 3rd to %

Thanks

Joe