Card Visual to return an absolute value

[NYT8er]

I have a Card Visual that shows a negative dollar amount and would like to have it show as a positive without transforming all the records in the data model.  Any possible way to do this without special programming?

[Ashish_Mathur · Accepted solution]

Hi,

Use the ABS() function - https://docs.microsoft.com/en-us/dax/abs-function-dax.  You may also use this measure

=IF([your measure]<0,-[your measure],[your measure])

[NYT8er]

---

@Ashish_Mathur wrote:

Hi,

Use the ABS() function - https://docs.microsoft.com/en-us/dax/abs-function-dax.  You may also use this measure

=IF([your measure]<0,-[your measure],[your measure])

---

There is no where for me to apply either function.  I only need the sum value to be returned as an absolute in the Card Visual.

[Ashish_Mathur]

Hi,

Go to Modelling > New Measure and use those functions.