Forum Discussion

nchamilton2's avatar
nchamilton2
Frequent Visitor
1 year ago

Relationship Filtering

Good afternoon, I have a Fact table with ProcedureID and ProjectID. I have a Project Table that connects to my fact table via ProjectId and is a one to many. My Procedure table connects to my Fact t...
Need Help
ajaybabuinturi's avatar
ajaybabuinturi
Super User
1 year ago

Hi nchamilton2,

I hope you have data model below. There is no filteration from Fact to Procedure to Notes. All these are single direction filter. You need to use/try Bidirectional filter to filter the data based Project. Please let me know if you have any questions.

Modified Model

 

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

 

nchamilton2's avatar
nchamilton2
Frequent Visitor
1 year ago

Thanks for the reply. Yes I tried that solution.

    • nchamilton2's avatar
      nchamilton2
      Frequent Visitor
      1 year ago

      No it didn't work, but  thank you.

       

      • v-aatheeque's avatar
        v-aatheeque
        Community Support
        1 year ago

        Hi nchamilton2 ,


        Thank you for bringing this up, and apologies for the inconvenience you're facing.

        As some of the community members have already shared helpful suggestions, we’d like to assist you further  but to do so effectively, we kindly request that you provide sample data that illustrates the issue clearly and completely.

         

        Make sure not to include sensitive or unrelated data.This will help us reproduce your scenario and provide an accurate solution tailored to your issue.

        How to provide sample data in the Power BI Forum - Microsoft Fabric Community

         

        Looking forward to your response!