cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## 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" in the case that the second value is greater than the first, obviously it returns a negative number as a result. How can I make the result that I always subtract in second place from the number with the lowest value and show me the name of who that difference corresponds to. I clarify that the calculation will always be performed only between two values. Thanks!

1 ACCEPTED SOLUTION
Super User

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

3 REPLIES 3
Community Support

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

Super User

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

Super User

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.