Forum Discussion

richard-powerbi's avatar
richard-powerbi
Icon for Post Patron rankPost Patron
6 years ago

Filter dimension tables in Star schema?

First I had a flat table and when I filtered in the filters pane, it would also filter out the other 'dimension columns'. Now I made it into a star schema and when I filter 1 dimension in the filter...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I don't think so unless you make some common table that associates all the foreign keys from those all tables.

 

BR,

DR

richard-powerbi's avatar
richard-powerbi
Icon for Post Patron rankPost Patron
6 years ago
Yea that might be a better solution. I'll accept it as a solution once I've implemented it.
  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi richard-powerbi ,

     

    How about the result after you follow Anonymous 's suggestions ?Could you please provide more details about it If it doesn't meet your requirement?


    Best regards,

     

    • richard-powerbi's avatar
      richard-powerbi
      Icon for Post Patron rankPost Patron
      6 years ago

      I still have to implement this, when I have no other questions I'll accept it as a solution.