Forum Discussion
How to utilise USERELATIONSHIP for multiple dates in multiple tables from a Date table?
Hello there, I have three different dates each in different tables that I am currently trying to use. I have created a Date table and I want the date table to use the Created Time dates from the Deals, Purchase Orders and Invoices tables (columns needed are marked red in the image below):
However, due to how many tables and relationships I have, I can only have one relationship activated for the Date table. However, I know that inactive relationships can be utilised with the USERELATIONSHIP() function.
How would I be able to use this function for a date slicer that filters all these three dates through the date table simultaneously? (Slicer example shown below):
So when I click on any of the buttons it will show me the relevant date for Invoices, Purchase Orders and Deals all at the same time (that's what I'm trying to achieve through USERELATIONSHIP). Any help would be appreciated.
4 Replies
Anonymous , these join are inactive because of other bi-directional joins. Each table you can have one active join.
Make all 1-M join from dimension to fact -> single direction.
And then try to activate these joins
amitchandak I do understand that, but I can't do that in this case because I need to filter in multiple directions in my dashboard and I have 10 tables that are all linked together. I've tried making them all 1-M and one-directional but then I can't use any of the filter options that I want to use.
It's quite complex to explain. But this is why I was hoping I could use USERELATIONSHIP to solve this problem.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)
