Filter a Fact table depending on another fact table column

[Tybaal]

Hi everyone, 

I have an issue on a report a develop.

I have this model (simplified):

Two fact table, both linked to my dimensions.

I have a summary page like below:

Until here, no issue.

The slicers 1 to 4 are dimension data and the slicer 5 (boolean) comes from the Fact table 1.

The issue I have is that in the table result, I can Drilldown to a detailed page where I have data coming from Fact table 2. So my filters coming from slicers 1 to 4 (dimension data) are well applied, but the slicer 5 coming from Fact table 1 is not applied in the drilldown.

This data for slicer 5 is a boolean and it's in both Fact table 1 and 2.

So what I would like to do is to filter my drilldown result page with all the slicers selected in the summary page.

Someone can help on this point?

Thank you in advance.

[Tybaal]

The report in in Direct query mode.

[Tybaal · Accepted solution]

I created a boolean dimension with 2 values (TRUE, FALSE) and linked it to my fact tables so it works.