unit of measure - many to many

[Anonymous]

Hi,

I have two tables with a many to many relationship:
1. Fact table: Sales qty by item. UOM = "CA" Cases
2. Conversion table of units of measures by item: Each item has 2 possible conversions. "EA" units and "LT" Liters.

I want to create 2 different DAX formulas:
1. Qty EA = Qty in fact table x conversion
2. Qty LT = Qty in fact table x conversion

Attached a simplified model in case it helps

https://www.dropbox.com/scl/fi/ckswmf98eef3equ727eus/UOM-Conversion.pbix?rlkey=h8bs72eavdl8dp55jmdaq...

Thank you very much for your help.

[lbendlin]

Your sample data doesn't match the description. No many to many relationship (which is a good thing)

but also no UOM CA, but instead LG

please clarify and provide more fitting sample data.