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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I resolved this by placing the following measure in the "Filters on this Visual" on the slicer

ApplyToFilterVisual = if(Quantity[Quantity by Delivery Date]>0, [Quantity by Delivery Date], Quantity[Quantity by Order Date])
 
The value on filter is set to greater than zero
 
The Slicer is the Item[Items] and the relationship cardinality is Single