Forum Discussion
Solved
Model design issue For Many Dimension and Fact Table
Hi Everyone, I am using Database Table & View to construct Power BI Model. My goal is combining multiple dimension tables into one dimension table to control all the fact tables. There are t...
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 , 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