Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX - USERELATIONSHIP for slicers

Hi,   I would like to get a help on setting up a USERELATIONSHIP function to activate a slicer.   Here is my data model with 3 records only (Table name = QuantityTable). The table contains 4 col...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous change your cross filter direction to single between item and quantity table. Double click on relationship and that is where you you change the direction from both to single.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Emily,

 

Thanks for detailed explaination.

 

Here is the alternate methodSolution

 

Let me know if this works!