Forum Discussion

Vanchy_Liao's avatar
Vanchy_Liao
Advocate IV
4 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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's avatar
Vanchy_Liao
Advocate IV
4 years ago

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 ^^

amitchandak's avatar
amitchandak
Super User
4 years ago

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's avatar
    Vanchy_Liao
    Advocate IV
    4 years ago

    amitchandak ,

    Thank you for your advise and I decide to change my model into star schema