https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Kilograms-to-Tons/m-p/1465180#M27707 <P>Dear All,</P><P>I am new to power bi. I want to create one meaure. I have sales in Kilograms. I am trying to convert it into Tons through a meaure, but not able to do it.</P><P>&nbsp;</P><P>Can you please help. DIVIDE('New sheet Rayees'[Standard Qty],1000,0) - This was done earlier. Now trying to do the same, but not getting [Standard Qty] without putting sum, which it is not taking.</P> Fri, 30 Oct 2020 07:19:56 GMT Anonymous 2020-10-30T07:19:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Kilograms-to-Tons/m-p/1465180#M27707 <P>Dear All,</P><P>I am new to power bi. I want to create one meaure. I have sales in Kilograms. I am trying to convert it into Tons through a meaure, but not able to do it.</P><P>&nbsp;</P><P>Can you please help. DIVIDE('New sheet Rayees'[Standard Qty],1000,0) - This was done earlier. Now trying to do the same, but not getting [Standard Qty] without putting sum, which it is not taking.</P> Fri, 30 Oct 2020 07:19:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Kilograms-to-Tons/m-p/1465180#M27707 Anonymous 2020-10-30T07:19:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Kilograms-to-Tons/m-p/1465561#M27716 <P>Hi Anonymous</LI-USER>&nbsp;</P> <P>Try</P> <P>DIVIDE( SELECTEDVALUE( 'New sheet Rayees'[Standard Qty]) ,1000)</P> <P>&nbsp;</P> <P><STRONG>Please mark the question solved when done and consider <FONT color="#FF9900">giving a thumbs up if posts are helpful.</FONT></STRONG></P> <P><FONT color="#FF0000">Contact me privately for support with any larger-scale BI needs, tutoring, etc.</FONT></P> <P>Cheers&nbsp;</P> <P>&nbsp;</P> <P><img /></P> Fri, 30 Oct 2020 09:45:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Kilograms-to-Tons/m-p/1465561#M27716 AlB 2020-10-30T09:45:10Z