override subtotals in a matrix

[Jaya]

Is it possible to override the subtotals in a Power BI matrix so that it does not include a specific item? Something like below where the NY amount is not included in subtotals. TIA.

State	Budget
CT	500
MA	1500
NY	1000
Subtotals	2000

[smpa01]

@Jaya try this measure

X= IF(HASONEVALUE('Table 1'[State]),CALCULATE(SUMX('Table 1','Table 1'[Budget])),CALCULATE(SUMX(FILTER('Table 1','Table 1'[State]<>"NY"),'Table 1'[Budget])))

[Jaya]

That works perfect but I want the NY value to be displayed in the matrix though. It should show but do not calculate on subtotals. Thanks so much!

[smpa01]

did you try it yet ?

[Jaya]

Yes I did. The value is not counting towards the subtotals which is what I want but I also want the value to show across the NY row.

[smpa01]

[Jaya]

Below is how the matrix looks on my end

State	Actual	New
CT	500	500
MA	1500	1500
NY	1000
Subtotals	3000	2000

[Jaya]

Hi,

Any ideas about what would I do if the column "Budget" is a measure. I have a measure called "Remaining Balance" which is the actual value minus the budget value. I have used a measure because Budget value comes from a different table. 

When I use the DAX you sent it is giving me all incorrect values.

TIA,

[Jaya]

You are the best! Thanks so much!

[Greg_Deckler]

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also, check out MM3TR&R: https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...