DAX Many-to-Many OR ?

[slyfox]

Coleagues,
i'm looking for a solution where with help of DAX formula I can retrieve data from fact table to another fact table joined over the same dimenssion table.
The datamodel itself looks like:
F_Table1->D_Table1<-F_Table2->D_Table2

So, what I need is to find:
for every row of F_Table1.[Field1] the the sum of values from F_Table2.[Column1]+F_Table2.[Column2]
where F_Table2 is filtered by condition from D_Table2 like where D_Table2.[Field1]=1.

 

[Tianbas]

A few more details would help. At least I do not understand how this math should work. In your formula you do not describe any relationship to the 1st fact table, so it would show the same value for all rows. Do you need that as a calulated column in F_Table1 or as a measure in the pivot ?

Maybe as a rough guidance you probably need CALCULATE(SUM(F_Table2.[Column1]),Filter(F_Table2,... and then something like RELATED, RELATEDTABLE or EARLIER with a column of D_Table2 as filter criteria depending on how the relationships between these tables look like

 

[slyfox]

Tianbas, all tables has a link field LINK_Order_Nr
table names looks like: Fact_Order_Sales->Dim_Order_Details<-Fact_Order_CostsElements->Dim_Cost_Elements
So I need summary of specific Fact_Order_CostsElements filtered by Dim_Cost_Elements for every row at Fact_Order_Sales table.
and yes I need it as measure.

 

[scottsen]

I still haven't convinced myself you have a "real" m2m problem here. Best case, can you link a sample workbook (dropbox,onedrive,googledrive,whatevs). 2nd best case, at least a screen shot of your model?