Applying the USERELATIONSHIP Function on a Time Intelligence Slicer

[@sue_bayes]

I particularly like the use of userelationship and how you have organised your measures.

[@anupajayakody]

I used this to get Last year sales, but when a quarter or month is selected, it gives an error that sameperiodlast year should have contingous dates, any idea how to fix this, I believe it is coming because of the bidirectional relationship between the timeintelligence date column and the date table date column

[@HavensConsulting]

One thing is you could change the relationship to many-to-many, and then enforce a single direction of that filter. Which may solve the problem?

[@SaniGarba]

I see what you did here, Reid. A subtle reply to Adam Saxton at GIAC regarding his note of caution in the use of biD r/ships. Without taking sides, and watching this video, I’d say both of you are correct. Thanks for your awesome tutorials.

[@HavensConsulting]

Hah, Adam is great, and I always appreciate his mentions of my videos. Even from my first video I mention caution with these relationships, always planned to elaborate more on the part 2 for this. :)

[@1yyymmmddd]

Isn't it easier to use Format-Edit Interactions instead?

[@havenscr]

Fair question. As I mentioned at the beginning of the video. Leaving the bi-directional relationship on would require you to edit the interaction between every new visual you add to any report page. This could lead to dozens of visuals needing to be manually disabling that connection, and it’s very easy to forget to turn this relationship off whenever adding a new visual to a page. It’s much easier for development to just build a few measures with this connection enabled, and have all other visuals automatically not use that relationship, since it’s disabled in the model.

[@spilledgraphics]

excelent!!! =USERELATIONSHIP () added to my toolkit :P ...amazing explanation. Though, could do more examples?

[@HavensConsulting]

Someday I'll do other videos on this function I'm sure. dax.guide/userelationship/ this is also a good article on the function as well