topic Re: DAX - remove decimal places in measure in DAX Commands and Tips

DAX - remove decimal places in measure

Lauri — Sat, 13 Aug 2022 23:32:17 GMT

I have the following measure but not sure how to make it so it returns 0 decimal places in result.

Count Employee No Blank = IF(ISBLANK(COUNT('Employee List'[Full Name])), "0", COUNT('Employee List'[Full Name]))

Thank you!

Re: DAX - remove decimal places in measure

daXtreme — Sun, 14 Aug 2022 08:15:57 GMT

Hi Lauri

A measure should not be formatted when it's calculated; it should always return the raw number.

Formatting should be done through the UI:

Re: DAX - remove decimal places in measure

hb-webdev — Thu, 20 Aug 2026 21:23:21 GMT

Doesn't work. Whether I make it a whole number or decimal number, setting the decimal count does literally NOTHING. And I KNOW I'm on the correct field, because when I change the Format to Percentage, a "%" gets added:

Re: DAX - remove decimal places in measure

miknieeco — Fri, 21 Aug 2026 07:46:28 GMT

Navigate to "Value" settings the visual pane - It can be different in each visual but in a linechart its here: under "Data labels"

And set the display units or decimal places here