topic Re: Making slicer that will fiter between separate tables in DAX Commands and Tips

Making slicer that will fiter between separate tables

Anonymous — Wed, 01 Apr 2020 00:36:42 GMT

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)

Re: Making slicer that will fiter between separate tables

Pragati11 — Wed, 01 Apr 2020 08:38:47 GMT

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

Re: Making slicer that will fiter between separate tables

Anonymous — Wed, 01 Apr 2020 13:47:12 GMT

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?