Forum Discussion

RavitPBI's avatar
RavitPBI
Frequent Visitor
5 years ago
Solved

DAX using USERELATIONSHIP is not working for an inactive relationship

Hi Folks,   Table1: Dim_LaborShift Table2: Fact_HoursPlanner   Data model:   I am trying to create matrix which shows "Total Shift Length" for a particular User on a particul...
DAX
DAX Calculation
INACTIVE RELATIONSHIP
USERELATIONSHIP
  • edhans's avatar
    edhans
    5 years ago

    Great RavitPBI if you could mark one or more of the responses in this thread as the "Solution" that would show others it is closed. Hope your project continues to go smoothly.

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

"The only option I see that avoids, both, bi-directional and inactive relations is to have multiple RLS tables attached to the necessary dimensions to filter them down based on logged-in user."

 

Without more info on the model and looking at it, I cannot say if that is the only option, but it sounds reasonable. And without question I would implement that strategy vs the bi-di strategy. One is a little more front end work. The latter has all sorts of side effects, that are currently causing issues and will continue to do so in the future.

RavitPBI's avatar
RavitPBI
Frequent Visitor
5 years ago

Thanks again, edhans, for sharing your thoughts. I implemented the former design strategy and it is working as it should. Like you said, in the long term there is minimal-to-no risk of any surprising results with this approach.