Forum Discussion
Best Way for work with Multiple Fact Tables
Hi everybody!! which is the best technique for working with models that have multiple fact tables and so get a star schema?. For example, in QlikView there is a technique called "linktable". ...
"Only downside of this is that now dimension tables does not filter each other, so i remain with many values to pick from inside my slicers allthough not all are relvant after few filters have been applied to my fact tables."
Create a measure in your fact table with countrows.
Then, filter the slicer (using the slicers applied to this visual feature) by that measure being > 0.
-jpr
Sounds interesting, but do not fully undertstand. Could you explain in more detail? 🙂
I recommend looking at the following link:
https://powerpivotpro.com/2016/02/data-modeling-power-pivot-power-bi/. While link tables can be done, i think it's much easier and better to keep things simple. Hope this helps.
