Forum Discussion
Card Visual to return an absolute value
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?
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])
3 Replies
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])
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.
Hi,
Go to Modelling > New Measure and use those functions.
