Forum Discussion
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.