Correct totals of sum column X or Y

[Sparkeltje]

Hello guys,

I have trouble calculating the correct grand total.

The table has two colums with amounts and I want to calculate the sum of column x when not empty AND if empty then calculate column Y.

To get to the solution I have an measure to calulate X and one to caluclate Y. Then I did the next IF statement:

Inv.IF =

IF([Inv_X] <> 0 , [Inv_X], [Inv_Y])

It works on row but the grand total is the sum of Inv_X.

When you select only data with date form Inv_Y, the total is of only Inv_Y.

How can I calculate the sum when Inv_X <> 0, then calculate Inv_Y and see the correct grand total?

[Greg_Deckler]

@Sparkeltje 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

[Sparkeltje]

Sorry I forgot something.

The table also has a column named COSTSAVINGS and caluclations of SUM is only for the COST.