Forum Discussion
DenBI
8 years agoNew Member
problem with drillthrough and relationships (cardinality)
I can't get my head around an issue. I have two tables with data, one containing slotreport data (high level data), and on containing slotdetails data (fine grain data) containing more details about ...
Seward12533
Solution Sage
8 years agoHard to tell from what you provided but try one of these. Dealing with multiple fact tables can get a bit tricky.
- Filter on Slot from your Bidge Table this will force the filter down into both tables.
- IF you need to filter on somethign else then you can set the relationship between the bridge Table (SlotIDs) and the SlotReport table Bidirectional. This will force the filter to flow back up and then down into the other table.
- You can use a trick to force the filter context by writing a measure for the slotdetail data that explicitly references the SlotReport table by specifying the table name within a calcualte. (see some screen shots below)