Technique to use captured filters from Drillthrough, on another visual

[Anonymous]

Greetings, I was trying to search for a good approach to capture filters and reuse them in filtering another table. 

Here are the details.

These are some filters that i can pass through a drillthrough from a visual on Table1 (page1), to a visual on Table2 (page2).

It works good and gives me a filtered table visual on table 2. Here is a screensnip of filters affecting the visual.

Table2 Visual (page 2) :-

I successfully obtain filtered items on Table2 Visual. 

I can also successfully capture them with Selected Value function on page2.

What i would like to achieve is, i have a summarized dax table. - Table 3. 

Table3 has [SourceAndID] column, just like Table2

Table2 and Table3 have a relationship in the data model as well. (attached below)

Table2 has duplicates of SourceAndID for my requirement and this is why i need to capture the distinct [SourceAndID] list after the drillthrough, and filter my Table3.

-- > My approach has been around using Selected Value ; then using

        var1 = selectedValue ( tablex[item1] ) , var2 = selectedValue( tabley[item2] ) . . .

        CALCULATETABLE ( Values ( [SourceAndID], FilterCondition1 = var1 , FilterCondition2 = var2 )

Further infos on the data model : 

They do not have a direct relationship but a small dimension/bridge table with distinct values help me establish a relationship.
I am also making sure to use the column taken from the smaller table in my visuals. 

I've had ideas if i could capture the distinct list of required column values with virtual tables and see if i can apply them on visual 3. But i have had no luck about it. 


Sample Result! :

Table2 is in this shape after the drillthrough filters.

Table3 desired result :

Any suggestions, approaches and help are greatly appreciated!

[Anonymous · Accepted solution]

I've got an answer to this. It was fairly easy and something i missed from the Relationship model and not DAX.

The answer : 

Just make sure the source table from which a filter / resultant filter / criteria propagates !! is bidirectional, 

Then the target dimension/fact/table will get filtered automatically. 

[v-easonf-msft]

Hi , @Anonymous 

Glad to hear that the problem was solved! Thank you for sharing.

Best Regards,
Community Support Team _ Eason