Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX Help - Criteria from multiple tables

Hey All,   I have a situation where I need to create a measure that takes into account data from multiple tables.   The first table is a membership table. There is a row for each person and the m...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

     Hi all,

     

    Thanks for all the help. After digging into this further I found that the issue is likely due to the relationship passing through an intermediate table which was confusing the DAX. I used SQL to bring the data over to one table and the calculation is no working properly.

     

    James

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Create a relationship from the Data column in your transaction table to the date column in the Calenda Table.  In the Calendar Table, create two additional columns for Year and Month.  Year = YEAR(Calendar[Date]) and Month = FORMAT(Calendar[Date],"mmmm").  In your visual, drag Year and Month from the Calendar Table.  Write this measure

 

Total sales = SUM(Data[Sales])

 

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

     Hi all,

     

    Thanks for all the help. After digging into this further I found that the issue is likely due to the relationship passing through an intermediate table which was confusing the DAX. I used SQL to bring the data over to one table and the calculation is no working properly.

     

    James