https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefined/m-p/2996328#M100986 <P>Hi,<BR /><BR />The amount of decimals displayed is a formatting setting. Check how many decimals you have here (in my example I have 0):&nbsp;</P> <P><img /></P> <P>If you want to change this with dax use FORMAT function e.g. FORMAT([measure],"#")<BR /><BR />This will display your number with 0 decimals.<BR /><BR />I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!<BR /><BR />My LinkedIn: <A href="https://www.linkedin.com/in/n%C3%A4ttiahov-00001/" target="_blank" rel="noopener">https://www.linkedin.com/in/n%C3%A4ttiahov-00001/</A><BR /><BR /></P> Mon, 02 Jan 2023 06:33:44 GMT ValtteriN 2023-01-02T06:33:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefined/m-p/2996288#M100982 <P>Hello team, I want to remove the decimal places from a measure. For ex. If value is 4.00 I want to display it as 4.</P><P>I have used below dax fir it. But not working.</P><P>Avg days = trunc(avg(orders[delivery days]))</P><P>Please help </P><P><img /></P> Mon, 02 Jan 2023 05:53:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefined/m-p/2996288#M100982 aditi11 2023-01-02T05:53:47Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefined/m-p/2996328#M100986 <P>Hi,<BR /><BR />The amount of decimals displayed is a formatting setting. Check how many decimals you have here (in my example I have 0):&nbsp;</P> <P><img /></P> <P>If you want to change this with dax use FORMAT function e.g. FORMAT([measure],"#")<BR /><BR />This will display your number with 0 decimals.<BR /><BR />I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!<BR /><BR />My LinkedIn: <A href="https://www.linkedin.com/in/n%C3%A4ttiahov-00001/" target="_blank" rel="noopener">https://www.linkedin.com/in/n%C3%A4ttiahov-00001/</A><BR /><BR /></P> Mon, 02 Jan 2023 06:33:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefined/m-p/2996328#M100986 ValtteriN 2023-01-02T06:33:44Z