Mapping 2 rows with 1 field

[EmmyAmsterdam88]

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:

Hereby the material recipe detail example:

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

[zenisekd]

Kudos and mark as reply appreciated 🙂

[EmmyAmsterdam88]

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:

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 · Accepted solution]

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

Kudos and Mark as solution appreciated 🙂