topic Re: How to Sum values in the same section - including filtering in DAX Commands and Tips

How to Sum values in the same section - including filtering

mic_rys — Sat, 16 Dec 2023 11:53:19 GMT

Hi,

I have a problem with the DAX mesaure and I'm looking for the dax master 🙂

my table:

Customer	Task ID	TabName	FieldName	Value txt	Value int
A	1	1_1	PromoName 1	Cars
A	1	1_1	Quantity 1		2
A	1	1_1	Avail 1	No
A	1	1_2	PromoName 2	Bikes
A	1	1_2	Quantity 2		1
A	1	1_2	Avail 2
A	1	1_3	PromoName 3	Moto
A	1	1_3	Quantity 3		4
A	1	1_3	Avail 3	Yes
A	2	1_1	PromoName 1	Cars
A	2	1_1	Quantity 1		2
A	2	1_1	Avail 1	No
A	2	1_2	PromoName 2	Bikes
A	2	1_2	Quantity 2		5
A	2	1_2	Avail 2
A	2	1_3	PromoName 3	Moto
A	2	1_3	Quantity 3		4
A	2	1_3	Avail 3	Yes
B
B
etc

my case:

In the report is Slicer/filter which select Promo name from column Valuetxt (created as Starts with "Promo").

In exaple will be: Cars, Bikes, Moto.

problem:

1. how to sum column Value int for selected eg. Cars with the same Tab ID (1_1 etc)

2. how to sum column Value int for selected eg. Cars with the same Tab ID (1_1 etc) and TaskID (1 etc)

Reports columns (selected promo = Cars)

1. Customer

2. TaskID

3. Sum Value int for the Cars

---

1. Customer

2. Sum Value int for the Cars

In short; I need to sum up Value int for the selected promotion from the same TabID and TaskID then summarize for Customer, Task OR only Customer.

Thanks a lot for the help !:)

Re: How to Sum values in the same section - including filtering

FreemanZ — Sun, 17 Dec 2023 13:54:19 GMT

hi mic_rys ,

not sure if i really get you, please try:

1) plot a slicer with data[Value txt];

2) plot a table visual with data[customer] and/or data[task ID] and a measure like:

measure = VAR _txt = SELECTEDVALUE(data[Value txt]) VAR _tabname = MAX(data[TabName]) VAR _result = CALCULATE( SUM(data[Value int]), ALL(data[Value txt]), FILTER( ALL(data[TabName]), data[TabName]=_tabname ) ) RETURN _result

it worked like:

Re: How to Sum values in the same section - including filtering

mic_rys — Tue, 19 Dec 2023 11:06:40 GMT

thanks a lot! I did a little modification in the measure:

VAR _promo = SELECTEDVALUE(Tasks[Value])

VAR _section = VALUES(Tasks[Tab])

VAR _result =

CALCULATE(

SUM(Tasks[Value int]),

ALL(Tasks[Value]),

FILTER(

ALL(Tasks[Tab]),

Tasks[Tab] in _section

)

RETURN

_result

because can appear more than 1 tabname in one taskid and now a have another problem because in the total measure shows wrong values.

In total measure add values to taskID from the other which exists the same TabName; but not selected in the slicer (Train).

Could you help me?:)

(how to add a pbi project to the post?:))