Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I've got such a matrix.
Rows: Channel, Customer, Segment; Columns: Year-Period; Values: MyMeasure = IF(Table[Amount]<0;0;Table[Amount]).
Surely, PBI calculates totals not as I expect it. As you can see the sum of Segments doesn't equal Customer's subtotals.
2019-P09 | 2019-P10 | |
Channel-1 | 70 | 75 |
Customer-1 | 50 | 45 |
Segment-1 | 10 | 10 |
Segment-2 | 20 | 10 |
Segment-3 | 30 | 30 |
Segment-4 | 0 | 0 |
Customer-2 | 20 | 30 |
Segment-1 | 10 | 15 |
Segment-2 | 0 | 0 |
Segment-3 | 20 | 20 |
I tried this measure: SUMX(FILTER(VALUES(Table[Segment]);Table[Amount]>0);Table[Amount])+0
Now I have correct subtotals at the level of Customer, but at the Channel level of hierarchy subtotals are still incorrect.
2019-P09 | 2019-P10 | |
Channel-1 | 70 | 75 |
Customer-1 | 60 | 50 |
Segment-1 | 10 | 10 |
Segment-2 | 20 | 10 |
Segment-3 | 30 | 30 |
Segment-4 | 0 | 0 |
Customer-2 | 30 | 35 |
Segment-1 | 10 | 15 |
Segment-2 | 0 | 0 |
Segment-3 | 20 | 20 |
Please, help me to write the correct DAX for this matrix.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
53 | |
46 | |
16 | |
12 |