Forum Discussion
Solved
DAX
Hi Community, Help me with the DAX to Display Total in Card. Id and Count, Eliminate are Raw Data. Target is dynamic user input. Difference is Count-Target (Obtained by DAX) Negative Diff...
Ok! Try this:
Negative Value = SUMX ( SUMMARIZECOLUMNS ( 'Table'[ID], "Diff", [Difference], "Negative Difference", IF ( [Difference] < 0, ABS ( [Difference] ), 0 ) ), [Negative Difference] )
As I have written, You must create a calculate column [Negative Difference], and pass it as the argument of SUM.
It works for me!