Forum Discussion
Model design issue For Many Dimension and Fact Table
Vanchy_Liao , if you have an objective to restrict the slicer value because of another slicer refer to this video
https://www.youtube.com/watch?v=cyOquvfhzNM
In your case, you need a measure which from three facts. example
countrows(Fact1) +countrows(Fact2) +countrows(Fact3)
Vanchy_Liao , You should try to be in Star Schema. 3 Dims can join with Three Facts. Do not merge or append unless that is the option
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
https://www.youtube.com/watch?v=vZndrBBPiQc&feature=youtu.be
Hi amitchandak ,
I realize the importance of star schema, but I want the slicer with cross filter interations.
How can I achieve this?
Thanks for your reply ^^
Vanchy_Liao , if you have an objective to restrict the slicer value because of another slicer refer to this video
https://www.youtube.com/watch?v=cyOquvfhzNM
In your case, you need a measure which from three facts. example
countrows(Fact1) +countrows(Fact2) +countrows(Fact3)
Thank you for your advise and I decide to change my model into star schema
