Filtering with inactive relationships

[EWBWEBB]

I have a Dim_Location table which contains the Cost_Code of each business area.

I have a Fact_InternalChange table which contains the Cost_Code a person is moving from and to.

Dim_location is joined to Fact_InternalChange on 'From_CostCode' with an active 1-* relationship

Dim_Location is joined to Fact_InternalChange on 'To_CostCode' with and Inactive 1-* relationship

What I would like to be able to do is add a slicer so that a person can filter the Fact_InternalChange by either From_CostCode OR To_CostCode without the need to introduce a second Dimensions table.

I've seen a few things on the forum but not from this specific angle.

[amitchandak]

@EWBWEBB , if you want to filter the same values, then the single table(Inactive join), and userelationship can help

Example activate inactive join

calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Sales'[CreateDate], 'Date'[Date]))

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

[EWBWEBB]

Hi @amitchandak 

I'm not sure I understand this approach.....potentially me being simple and highly likely a bad explanation.

I want to put the department from the Dim_Location table into Slicer1 so a person can slice the Fact_InternalChange table by the from department THEN put department into Slicer2 so they can filter by To department. 

This is all based on the cost code.

I'll likely use, USERELATIONSHIP to populate the data into the visual as a measure but I can't work out how to use it to affect the interaction of a slicer.