# DAX Many-to-Many OR ?

#### slyfox

##### New Member
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
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
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
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?

1,078,437
Messages
5,340,278
Members
399,362
Latest member
iayb

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...