Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX Across Multiple Many-to-Many Table Relationships

Hi all,    I would please like some assistance with the below use case for DAX.   I have 3 tables with a many-to-many relationship and I want to do calculations where I multiply the values across...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    You may create 2 measures as below:

    Measure = SUM(TableA[Activity Amount])*SUM(TableB[Flow Multiplier])*SUM(TableC[Impact Multiplier])
    Measure 2 = SUMX(TableB,[Measure])

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous 

You may create 2 measures as below:

Measure = SUM(TableA[Activity Amount])*SUM(TableB[Flow Multiplier])*SUM(TableC[Impact Multiplier])
Measure 2 = SUMX(TableB,[Measure])

Regards,

eeew00's avatar
eeew00
Helper I
5 years ago

Did the trick! Simple easy solution! 🙂