Forum Discussion
Active relationship based on Slicer
Anonymous you need to unpivot table b and then set the relationship between both the table, after that it will work as expected.
To unpivot, select all column table b excep (those four columns) and right click after selection and clicking unpivot other column, it will give you two column attribute and value (change column name as per your need)
Now set relationship between table 2 with table 1 on attribute and selection.
Now if you filter from selection, you table2 will show respective values.
Super UserAnonymous unfortunaltey you cannot change active relationship on selection but in your dax measure you can use userrelationship function to make other function active based on selection.
Can I create user relationship like a custom column instead of measure, because If I use to measure data is changing as My selection criteria by remaining slicers' data is not getting filtered .
Any Alternate approach to a situation like this?
- parry2k
Anonymous userrelationship can be only used in measure. I exactly not sure whst you are trying to achieve, if you share sample data and what result you are looking for, it will help to see if there is alternate solution.