- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

# Substract measure from another measure: result should show 0,0 instead of -4,0E-8

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-22-2018 03:07 AM

Hello,

I have created a measure 'Delta' to show the difference between 2 other measures: 'Actuals' - 'Budget' (DeltaLEMTPFY Millions = [LE Millions] - [MTP FY Millions] ) . When the result comes close to 0, the result shows -4,0E-8. However it should show 0,0 (always 1 decimal)

In the matrix visual that I see I have set the decimals to 1:

Any idea how to solve this?

Thank you in advance!

Solved! Go to Solution.

Accepted Solutions

## Re: Substract measure from another measure: result should show 0,0 instead of -4,0E-8

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-22-2018 04:21 AM

You can round using the below DAX for a calculated column

Column = ROUND(Table2[Value], 1)

Difference before and after rounding off is shown in screenshot below

First image values are not rounded off while the 2nd image values are rounded off. The Other scenario of negative values also handled

All Replies

## Re: Substract measure from another measure: result should show 0,0 instead of -4,0E-8

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-22-2018 04:10 AM - edited 08-22-2018 04:14 AM

Hi @MartijnNL,

Power BI is showing the data as -4.0E-8 because the values for that case is -0.00000004.

So in this case you can round your values to the No. of decimals that you want. But again rounding off to 1 decimal will automatically show it as 0.0 and anyother negative value such as -5.2 will continue to show as -5.2

The Other aolution is that you should handle the negative values so that they are always replaced with 0. Once you do this the report will always show 0.0 whenever the value becomes negative. In this case a value of -5.2 will also be replaced with 0.0, which might not be desirable

## Re: Substract measure from another measure: result should show 0,0 instead of -4,0E-8

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-22-2018 04:13 AM

Hi thanks, but I want to show negative values also. So, whether the value is positive of negative it should always show 1 decimal. So in this example I would expect -0,0 as end result.

## Re: Substract measure from another measure: result should show 0,0 instead of -4,0E-8

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-22-2018 04:15 AM

So in this case you can round your values to the No. of decimals that you want. But again rounding off to 1 decimal will automatically show it as 0.0 and anyother negative value such as -5.2 will continue to show as -5.2

## Re: Substract measure from another measure: result should show 0,0 instead of -4,0E-8

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-22-2018 04:16 AM

Do you know how to round the figure? Round function is not working (or I am using it incorrecly). Or do I need another function?

## Re: Substract measure from another measure: result should show 0,0 instead of -4,0E-8

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-22-2018 04:21 AM

You can round using the below DAX for a calculated column

Column = ROUND(Table2[Value], 1)

Difference before and after rounding off is shown in screenshot below

First image values are not rounded off while the 2nd image values are rounded off. The Other scenario of negative values also handled

## Re: Substract measure from another measure: result should show 0,0 instead of -4,0E-8

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-22-2018 04:34 AM

Thanks that works! I made a mistake using the round function. Thanks for helping me!