Conditional filtering on unrelated table

Thanks both for your replies. After doing some testing, both suggestions work, although the ALLSELECTED() function in place of SELECTEDVALUE() in combination with using IN() with the CALCULATE() function is closer to what I was hoping to achieve.

There was also another way too which was to create two dimension tables with one column for Category and Sub-Category. Then in the model, create relationships between the Sales fact table and also the Targets table too. Then change the slicers to run from these Category and Sub-Category dimension tables. and the filters propagate through to both the Sales and Targets table. This also has the advantage of my slicer options not jumping around depending on previous slicer selections (I think from reading previous posts, slicers on dimension tables is better practice than slicers on fact tables, partly for this reason).

Thanks for the help though 🙂