Forum Discussion

luistiscornia's avatar
luistiscornia
Regular Visitor
5 years ago
Solved

undefined

Hello! I am new to PowerBi. I need help to know which formula to occupy so that the difference between 2 variable numbers of a calculation is always shown in positive value. Since if I use "calculate...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey luistiscornia ,

     

    you can use the ABS function to get the absolute number (the positive number) of a value.

    So if it's 715 it will return 715 and if it's -715 it will return 715.

     

    You can use that with your CALCULATE function:

    MyMeasure = ABS( CALCULATE( ... ) )

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey luistiscornia ,

 

you can use the ABS function to get the absolute number (the positive number) of a value.

So if it's 715 it will return 715 and if it's -715 it will return 715.

 

You can use that with your CALCULATE function:

MyMeasure = ABS( CALCULATE( ... ) )

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • AlexisOlson's avatar
    AlexisOlson
    Super User
    5 years ago

    Another option is to simply format the measure to not show the negative sign by changing the custom format to show positive and negative values the same.