DAX Many-to-Many OR ?

slyfox

New Member
Joined
Nov 20, 2014
Messages
2
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

Board Regular
Joined
Apr 29, 2014
Messages
101
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

New Member
Joined
Nov 20, 2014
Messages
2
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

Well-known Member
Joined
Mar 16, 2014
Messages
1,263
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?
 

Forum statistics

Threads
1,078,394
Messages
5,339,939
Members
399,340
Latest member
JasonT903

Some videos you may like

This Week's Hot Topics

Top