Forum Discussion
How to utilise USERELATIONSHIP for multiple dates in multiple tables from a Date table?
Anonymous , USERELATIONSHIP activate alternate join, so I doubt that is the case here. It inactive because there are two paths.
You can selectively disable bi-directional
To filter a slicer you can use measure from one or more facts and check for nonblank in the visual level filter
countrows(Fact)
or
countrows(Fact) + countrows(fact2)
amitchandak I'm not sure I understand what you're saying about slicers?
To explain, I have a Customer slicer (a search box) and once a Customer is selected, that filters other slicers such as Deals, so relevant Deals show up for that Customer. And in Deals and Customers there are invoices, purchase orders and other stuff that are filtered through it.
I need to have bi-directional relationships because of this, otherwise, I can only filter one way and there is limitations. For example, if I make everything single direction, if I search the Customer slicer, no Deals will show up because the relationship is lost between them, since they have to go through multiple tables first.