topic Re: Correct totals of sum column X or Y in DAX Commands and Tips

Correct totals of sum column X or Y

Sparkeltje — Thu, 17 Sep 2020 19:35:02 GMT

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?

Sparkeltje — Thu, 17 Sep 2020 19:45:47 GMT

Sorry I forgot something.

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

Greg_Deckler — Thu, 17 Sep 2020 20:35:26 GMT