cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## UOM conversion relationship with many to many

I have a main fact table and dim_uom table shown below.  Highlighted in yellow below is my desired output showing that the user has the ability to select from a dropdown "alternate_uom" so I am in need of creating the relationship between my fact table and dim_uom table with the issue of many to many.

1 ACCEPTED SOLUTION
Super User

@Powerline56 , Try a measure like

Sumx(Fact , Fact[Unit Price] * maxx(filter(DIM_UOM, DIM_UOM[Product_Num] = fact[Product_num] && DIM_UOM[Batch] = selectedvalue(Batch[Batch])), DIM_UOM[Conversion_factor]))

3 REPLIES 3
Community Support

Hi @Powerline56 ,

Create a Many to Many relationship and create a measure like below:

``Measure = SELECTEDVALUE(fact_table[unit_price])*SELECTEDVALUE(Dim_UOM_Conv[conversion_factor])``

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User

@Powerline56 , Try a measure like

Sumx(Fact , Fact[Unit Price] * maxx(filter(DIM_UOM, DIM_UOM[Product_Num] = fact[Product_num] && DIM_UOM[Batch] = selectedvalue(Batch[Batch])), DIM_UOM[Conversion_factor]))

Helper I

Thanks so much, this worked great.  Can you explain why you need to use maxx for this situation?

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors