How to get rid of Zero (0) after adding up a column with decimal places

[PowerBIData]

Hi,

Kindly advise if you're able, I have a decimal column datatype decimal on a  Day table as per below example.

Day

0.5

11.0

When I add this I get 11.5 which is correct, but when I add 1.0+1.0= 2.0, I would like to get rid of zero if is a whole number

Dax used  Total days=sum('day'.[day])+0

Basically, I would like to get rid of 0 if the sum is equal to a whole number.  Many thanks.

[Jihwan_Kim · Accepted solution]

@PowerBIData 

I suggest using a tabular editor in the Power BI desktop.

The type still remains as a number.

https://www.dropbox.com/s/0q2878rl8amj4n4/powerbidata.pbix?dl=0 

[selimovd]

Hey @PowerBIData ,

you can do that with DAX and the FORMAT function.

Check that article on how to do that:

Dynamic scaling of a measure in Power BI with DAX - What the fact.bi

Be aware that FORMAT returns a text. So this measure will work in a table or matrix, but not in other visuals like a bar or line chart.

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic