Forum Discussion
Solved
Indirect Relationship Needed
I have three tables with two relationships in a DirectQuery .pbix: Active From: Table (Column) To: Table (Column) Cardinality Cross filter direction TRUE Table3 (id) Table2 (id) Many to One (*:1...
This solution is even more brilliant. No messing with the relationship modeling, I just added this measure to the table visualization and let DAX do the rest. I go the inspiration from this article by Marco Russo.
use_cases = COUNTX(table3,
CALCULATE(VALUES(table1[id]),
FILTER(table1,
table1[id] = table3[id]
)
)
)Hope this helps someone.
Came to a solution after finding this article from Microsoft. I also recommend this article by sqlbi.com.
First I turned on bi-directional filtering, which is currently a Preview Feature in BI Desktop found under Options.
Then I made the table1:table2 relationship cross filter in both directions.
Although this solution is not exactly what I wanted because now my slicers are bi-directionally filtered, it gets me more than halfway.