Forum Discussion

Lee5150's avatar
Lee5150
Helper I
1 year ago
Solved

Filter Matrix using inactive relationship

Hi all,   Apologies if this has been covered elsewhere, but I am unable to find what I need. I thought this would work but I am unable to use it effectively. https://community.fabric.microsoft.co...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    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....

     

     

Lee5150's avatar
Lee5150
Helper I
1 year ago

Hi again, does anyone have any further info on how I can achieve this? I'm really struggling to formulate the measures correctly.

 

Many thanks

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

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....