Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 |
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.