Forum Discussion
Best Way for work with Multiple Fact Tables
Did you happen to find any help for your question? alexanderg anagnostes
I had the same situation.
What solved it for me was that i turned all the "Two Way Filtration" on relationships going out of my fact tables.
I eneded up with all relation ships from the dimension tables to the fact tables as one sided filtration: from the one side to the many side.
After that, Slicers from one dimension table filtered both fact tables well.
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.
If any one has ideas how to get that done i will be greatful. :)
This post helped me:
"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? 🙂
