Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
EmmyAmsterdam88
Frequent Visitor

Mapping 2 rows with 1 field

Hi all,

 

I have a set of data showing volume sales by material, however i would like to know the volume sold by the material base (recipe).

 

Underneath my fact table example:

 

EmmyAmsterdam88_0-1706001573728.png

 

Hereby the material recipe detail example:

 

EmmyAmsterdam88_1-1706001723162.png

 

So Material 1234 sold 20.000 * 0.4 = 8000 material base A. 

 

Does anyone know how i can connect these tables in order to get the correct volume by material base?

 

Thank you,

 

Emmy

 

1 ACCEPTED SOLUTION

zenisekd_0-1706007551672.png

zenisekd_1-1706007617512.png


Has one value is used in order to remove the summarization. 

Kudos and Mark as solution appreciated 🙂

 

View solution in original post

3 REPLIES 3
zenisekd
Super User
Super User

zenisekd_0-1706003214525.png

zenisekd_1-1706003230246.png

Kudos and mark as reply appreciated 🙂

 

Thank you,

 

Apologies i was not very clear, the fact table is like a big sold sales table with multiple of the same material nr's in the first column:

 

EmmyAmsterdam88_0-1706005116136.png

 

Therefore this relationship will give "many-to-many".

 

I believe i am searching for a dax which can connect these tables in order to have the correct volume by material base. Would you know of any?

zenisekd_0-1706007551672.png

zenisekd_1-1706007617512.png


Has one value is used in order to remove the summarization. 

Kudos and Mark as solution appreciated 🙂

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

October NL Carousel

Fabric Community Update - October 2024

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