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,437
Messages
5,340,278
Members
399,362
Latest member
iayb

Some videos you may like

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...
Top