Sign dependency between IF Dax

[Power_BI_new]

Hello,

I created this calculated column. I have a problem because the sign of the second IF impacts the sign of the 3rd IF. I tried to work around by storing the second IF in a variable but nothing worked. How can I avoid that the sign of the second IF does not impact the 3rd.

When I change the sign of the second if, it also changes the sign of the last if...

New =
IF ('Table'[Step] = "Ouverture", CALCULATE([T (n-1) cumul], 'repository'[category] = "1 - Net ", 'Table'[Code]= "IFRS new"),

IF ('Table'[Step] <> "", -CALCULATE([T cumul], 'repository'[category] = "2 - Total", 'Table[Code] = "new"), 

IF ('Table'[Step] <> "", CALCULATE([T cumul], 'repository'[category] = "3 - Cash Flows", 'Table'[Code] = "IFRS new") ) ) )

[tackytechtom]

Can you share a screenshot and describe the business logic? I think I have not yet understood what you would like to achieve 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Power_BI_new]

When I add the - in front of the 2nd IF, it shows me the correct results in my table, but it affects the sign of my 3rd IF. This turns my result into a negative for me, when I want it to be positive.

Between the 2- and the 3-, some lines share common accounts, I don't know if this can be the cause

[tackytechtom]

Hi @Power_BI_new ,

The if function works like this:

if ( Condition = TRUE, Result, AlternativeResult )

--> "if condition is true, return Resultl, else return AlternativResult"

In your case, I'd suggest this one here:

New =
IF ('Table'[Step] = "Ouverture", CALCULATE([T (n-1) cumul], 'repository'[category] = "1 - Net ", 'Table'[Code]= "IFRS new"),

IF ('Table'[Step] <> "", -CALCULATE([T cumul], 'repository'[category] = "2 - Total", 'Table[Code] = "new"), 

CALCULATE([T cumul], 'repository'[category] = "3 - Cash Flows", 'Table'[Code] = "IFRS new") ) ) 

Does this work?

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Power_BI_new]

Thanks for your answer but it doesn't work. I can't change the sign of the 3rd IF, I tried to put an ABS() but my number remains negative as if I hadn't put anything.