Convert kg, tons, lbs in new measure with Switch function

Hi Chaithanya89 ,

There are several approaches to this problem. You can use SWITCH or field parameters. For the former, you need to create a disconnected table (without relationship to fact table) that will serve as holder of the switch measure. Please see sample DAX formulas below:

Base Unit Table = 
DATATABLE ( "Unit", STRING, "Sort", INTEGER, { { "lbs", 1 }, { "tonnes", 2 } } )

lbs or tonnes = 
SWITCH (
    SELECTEDVALUE ( BaseUnit[Unit] ),
    "lbs", [Quantity (lbs)],
    "tonnes", [Quantity (tonnes)]
)

Please see attached pbix for the details

I'm enable to updload a pbix for some reason - but please see link here to my google drive: https://drive.google.com/file/d/1fF-qCpz3HXZRLTkTlgHyjpr-H14JmuHn/view?usp=sharing

Thank you