Forum Discussion

Tybaal's avatar
Tybaal
Helper II
4 years ago
Solved

Filter a Fact table depending on another fact table column

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.

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

2 Replies

    • Tybaal's avatar
      Tybaal
      Helper II

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