Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have successfully set up a slicer to dynamically change a calculation in a matrix table but the row totals are not calculating as desired.
My calculation is for [Release Strength] where the Strength is either fixed or variable (from a test). The slicer ([Strength] determines whether to apply the variable result to all markets, no markets or US only. Each row can have one or more Market but only one variable test result and one fixed test result. I therefore have a measure [Total Release] as:
Release Strength =
VAR
Strength = SELECTEDVALUE('Strength'[Strength])
VAR
Variable = SUM([Test Result])
VAR
Fixed = SUM([Fixed Result])
VAR
Market = MIN([Market])
RETURN
SWITCH(TRUE, Strength ="All", Variable, Strength ="None", Fixed, Strength ="US Only", IF(Market="USA", Variable, Fixed))
The issue I think is that I have to use aggregated values for the measure and the MIN([Market]) means that USA is being ignored if it's not the only market for the release.
For example:
| Market | Fixed Result | Vairable Result |
| Europe | 262,500 | 288,750 |
| USA | 850,000 | 935,000 |
If I choose to apply the variable result to US Only I get this, where 262,500 + 935,000 <> 1,112,500. The other two slicer options are working fine.
Column totals are working fine, as would be expected.
I am sure there's a simple fix but it's elduing me at the moment!
Solved! Go to Solution.
Sorted it. Quite simply, I added a second measure of:
Total Release = SUMX('Released Goods', [Released Units])
Sorted it. Quite simply, I added a second measure of:
Total Release = SUMX('Released Goods', [Released Units])
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!