Forum Discussion
Vanchy_Liao
Advocate IV
Advocate IVModel 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_LiaoAdvocate IV
Advocate IVHi 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 ^^
amitchandak
Super User
Super UserVanchy_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)