Making slicer that will fiter between separate tables

[Anonymous]

I am trying to make a slicer that will filter the content between different tables. Although the tables have the same column name, they cannot be appended for this exercise.

I need a DAX calculation that will allow me to filter the content based upon the content in the FILE column.

Does anyone know how to do this?

download data (PBIX file) 

[Pragati11]

Hi @Anonymous ,

Try creating a relationship on "FILE" column among these three tables.

You don't need a DAX for this.

If this helps appreciate a Kudos and mark it as a Solution! 🙂

Regards,

Pragati 

[Anonymous]

I am aware of creating the relationship, but I am trying to using a DAX calculation instead because I will be importing over 300 FILES. It would probably be inefficient to have 300 relationships pointing to the FILE INDEX table.

Would DAX be the best solution for this problem?