Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 !:)
Solved! Go to Solution.
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:
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:
thanks a lot! I did a little modification in the measure:
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
8 | |
6 |