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 Lee5150 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Many thanks! I just need help formulating the measures to get each matrix to display the correct info. Nothing I have tried has worked so far.