Forum Discussion

Aaron_Borns's avatar
Aaron_Borns
Frequent Visitor
9 years ago
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...
Need Help
  • Aaron_Borns's avatar
    Aaron_Borns
    9 years ago

    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.

Aaron_Borns's avatar
Aaron_Borns
Frequent Visitor
9 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    This solution worked really well, thank you