Forum Discussion
How to count multiple dims away?
Hi, I have a Fact table. This is connected to a DimDate with the Date field, working great.. ... and also connected to a lot of other Dim tables, working great.. I have connected my Fact to...
krimyr see below:
If I filter on the Fact column that has relationship to DimTable1, it wont affect the result. this will not, since fact table doesn't filter dimension table. There are ways to work with this but with your current relationship it will not.
If I filter on the DimTable1 column that has relationship to DimTable2, it wont affect the result. If dim table1 has relationship dim table 2 (1 to many) then it should work. Can you share relationship diagram?