Table drill down only applies to one Column

[WilliamA]

Hi guys,

I have 2 tables - a Summary and a Detail with the related fields sharing a many to many relationship. The report has 2 table visuals one for the summary and the other the details. When you select a row from the summary table it should filter the detail table on all the related fields. However, it appears to only be filtering on the active relationship. 

When I attempt to make all the relationships active, I get an error due to a set of indirect relationships.

My model looks like the following - 

The expected outcome is when a row is selected from the Credit_Note_Duplicates table, it should filter the CN_Duplicate_CNs_Fact table for all the related fields.  Both tables share relationships with a date table as well as a hierarchy table for locations.

Is it possible to filter on more than one column? 

[amitchandak]

@WilliamA , the other visual or the drill through visual should have the measure with userelationship to filter

example

Power BI Drill Through when Userelationship is used: https://youtu.be/1BM_WGATrQA