Forum Discussion
Filtering with inactive relationships
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]))
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.