Filtering Data from Identical Tables

[Anonymous]

Hi there,

Probably a very simple question but I am struggling to find the best solution. 

I have 6 tables which are identical (6 locations), imported from the 6 MS SQL data tables of the systems. In each table I have 2 fields:

- unique ID number

- enquiry date

I have created a date table and connected it with the enqury date of each of the 6 tables. I can now filter all the results on one date filter, which is great. However, how can I filter which location? I may want to compare location 1 and location 4 for example on a visual. Do I need to create a location table?

Thank you!

[Anonymous · Accepted solution]

Hi @Anonymous ,

Not needed. Create one slicer with Location.Capture the selected Location value from Slicer using 'selectedvalue dax' in new measure and then filter the data for selected location.

Thanks,

Rupesh Dhage

[Anonymous]

 Hi @Anonymous,

Is this solution working for you?

Regards,

Rupesh Dhage

[Anonymous]

Hi @Anonymous ,

Yes, I would do so with a distinct in a common table like you did with the date.

Let me know if it worked, if so mark as solution.

BR,

DR

[Anonymous]

Hi @Anonymous 

Thanks very much for your response. Would you mind walking me through the steps to achieve that?

Many thanks