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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.