Forum Discussion
Filter Matrix using inactive relationship
Hi Lee5150 ,
Apologies for the delay in response. The behavior you’re seeing is inherent to Power BI, as it processes data in this manner by default. However, I’ve adjusted the relationships based on your specific requirements by duplicating the necessary elements. While this approach may not be fully recommended in a practical scenario, it aligns with your needs.
I’ve attached the PBIX file please review it, and you should get a clearer idea of the adjustments made. Let me know if you need further refinements.
I hope this helps....
Hi, does any one else have an idea for this? Or does any one know what I might be doing wrong with the previous answer?
Many thanks
Hi Lee5150 ,
The issue likely persists because USERELATIONSHIP requires correct inactive relationships and no conflicting filters.
Please try.
1. Set Calendar[Date] to Completed Date (active), and to Start Date and Installed Date (inactive) in the Model view.
2. If it still only shows Completed Date, ensure no global or visual-level filters are overriding the measures (check the Filters pane).
I hope this helps....
Hi, and thank you again!
I still can't get this working. I started a new project and set everything up from scratch, and it's still not working for me.
Please see the we transfer link to my file. For some reason, I was unable to attach it.
Please could you tell me what I've done wrong?
Thank you again!
Hi Lee5150 ,
Thank you for sharing.
1. Only the relationship between DateTable[Date] and Completed Date is active.
2. Relationships with Start Date and Installed Date are inactive but still present.
3. Create separate measures using the USERELATIONSHIP function. Use these measures in your three separate Matrix visuals.
4. Each visual should reference only its corresponding measure. The month slicer will now work independently for each matrix visual, as each one uses its own relationship logic via the measure.