Forum Discussion
Working with Multiple Fact Tables & Dimension
Hi Guys, I have multiple fact tables that were in the center (see image below) then tags & calendar table. How can I connect them properly?
I found this blog already: https://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/ and this guide https://www.youtube.com/watch?v=TnyRsO4NJPc but still can't work it out.
Hi,
The cross filter direction should be Single for all relationships.
3 Replies
- Ashish_Mathur
Super User
Hi,
The cross filter direction should be Single for all relationships.
- Ashish_Mathur
I have never come across practical situations where i have to select Both in the Cross filter direction. I have alays used Single and have been able to solve most (if not all) problems.
Perhaps someone else can pitch in to answer your exact question.