Kilograms to Tons

[Anonymous]

Dear All,

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.

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.

[AlB · Accepted solution]

Hi @Anonymous 

Try

DIVIDE( SELECTEDVALUE( 'New sheet Rayees'[Standard Qty]) ,1000)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers