Forum Discussion

lepdeffard's avatar
lepdeffard
Frequent Visitor
3 years ago
Solved

Composite Model Help

Here is my situation:  - Table1 is from an existing dataset and pulled into my dashboard via DirectQuery  - Table2 is from a local Excel file (but will probably be changed to a Sharepoint file)  -...
Need Help
Tutorial Requests
  • lepdeffard's avatar
    lepdeffard
    3 years ago

    I was able to get this working by setting up a calculated table pulling the columns from the direct query table which I was then able to use to set up relationships with the imported table. My DAX code as follows:

    NewTable = CALCULATETABLE( SUMMARIZE ( Table1, <List of Table 1 Colums Needed>) )

     

    The list of Table 1 columns needed includes the "join" column. This works and I think will get me through, but definitely let me know if there is a better way to go about this task.

lepdeffard's avatar
lepdeffard
Frequent Visitor
3 years ago

I was able to get this working by setting up a calculated table pulling the columns from the direct query table which I was then able to use to set up relationships with the imported table. My DAX code as follows:

NewTable = CALCULATETABLE( SUMMARIZE ( Table1, <List of Table 1 Colums Needed>) )

 

The list of Table 1 columns needed includes the "join" column. This works and I think will get me through, but definitely let me know if there is a better way to go about this task.