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 Experts,
I am after retaining the interactivity between visuals and show % of total split by advance shipment.
When I use formula for base in line 3, the totals come out correct however i loose interactivity. But, when I use formula for base in line 4, I retain the interactivity between visuals. however totals for few months is not coming out right. Whats the best to address this.
#percentoftotal #dax #calculate
Solved! Go to Solution.
I used this on your sample data.
Measure 2 =
var curr = SELECTEDVALUE('Table (2)'[Vol])
var base = CALCULATE(sum('Table (2)'[Vol]),REMOVEFILTERS('Table (2)'[ADVANCE SHIPMENT]))
return COMBINEVALUES(",", curr, base)
It shows the split ok, just doesnt show the full 100% split for the total columns.
I used this on your sample data.
Measure 2 =
var curr = SELECTEDVALUE('Table (2)'[Vol])
var base = CALCULATE(sum('Table (2)'[Vol]),REMOVEFILTERS('Table (2)'[ADVANCE SHIPMENT]))
return COMBINEVALUES(",", curr, base)
It shows the split ok, just doesnt show the full 100% split for the total columns.
This is the sample data -
Released_YYYMM | Vol | ADVANCE SHIPMENT | RECLASS DEMAND TYPE |
22-Mar | 345 | No | Non-Warranty |
22-Mar | 757 | No | Warranty |
22-Mar | 158 | Yes | Non-Warranty |
22-Mar | 687 | Yes | Warranty |
22-Apr | 293 | No | Non-Warranty |
22-Apr | 597 | No | Warranty |
22-Apr | 163 | Yes | Non-Warranty |
22-Apr | 795 | Yes | Warranty |
22-May | 254 | No | Non-Warranty |
22-May | 765 | No | Warranty |
22-May | 136 | Yes | Non-Warranty |
22-May | 589 | Yes | Warranty |
22-Jun | 230 | No | Non-Warranty |
22-Jun | 559 | No | Warranty |
22-Jun | 167 | Yes | Non-Warranty |
22-Jun | 545 | Yes | Warranty |
22-Jul | 217 | No | Non-Warranty |
22-Jul | 555 | No | Warranty |
22-Jul | 159 | Yes | Non-Warranty |
22-Jul | 665 | Yes | Warranty |
22-Aug | 131 | No | Non-Warranty |
22-Aug | 333 | No | Warranty |
22-Aug | 55 | Yes | Non-Warranty |
22-Aug | 177 | Yes | Warranty |
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |