Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Solved! Go to Solution.
@Anonymous , 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]))
Hi @Anonymous ,
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
@Anonymous , 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]))
Thanks so much, this worked great. Can you explain why you need to use maxx for this situation?