Selecting Data via Slicer Options - TRICKY

[Anonymous]

Hi Experts 

Need help in pullng through the correct data from the two Master Tables called 1. Case_Date and 2. FME_Date based on the selction criteria made in the slicer. (see Screen Prints below) 

So Parematers are:

1. If New is selected then only pull data from Case Data Table

2. If Closed is selected then only pull data from FME Data Table

3. If both is selected then select a combination of bothh tables added togther...

is it possible to use a Union or Switch in dax to perform this....

This is the slicer options as detailed above...

This is the releationship between tables currently - both the CAse ID and FMECase are unique ID linking the two tables together..

[jthomson · Accepted solution]

One way would be to try to merge your two master tables, and when doing so make a custom field which indicates which initial data set they come from - you can then filter on that. Not sure how easy this would be given your data sets though

[Anonymous]

Just notcied that the columns in the two tables are not 100% the same.... could we not create a union between the two tables????

[Anonymous]

so basically custom column 1 = New, 2 = Closed etc...