Forum Discussion
nchamilton2
1 year agoFrequent Visitor
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...
ajaybabuinturi
1 year agoSuper User
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.
- nchamilton21 year agoFrequent Visitor
Thanks for the reply. Yes I tried that solution.
- ajaybabuinturi1 year agoSuper User
nchamilton2 Is that helps you?
- nchamilton21 year agoFrequent Visitor
No it didn't work, but thank you.