Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Kilograms to Tons

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's avatar
    AlB
    6 years ago

    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 

     

1 Reply

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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