Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic Selection - Multiple Categories

Hi All,   I would like to ask some help with the below.   I have Sales table connected with Customer table and Product table. Each customer in the Customer table is categorised 3 different ways (...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    danextian 

    Thanks a lot for your reply!

     

    If I understand correctly, your FACT table is actually a flat table that already contains all the details from DIMENSION tables. That's what you index and then use the index to create the artificial dynamic slicer. Really nice approach!

    Unfortunately, in my case it will not work, because:

    • I have lots of records in my fact table (invoice line items)
    • with my star schema there is no way to replicate what you did (it would be in a sense circular reference or kind of)

    My main problem is that the Divisional data must come from the Products table and have to use the selected value from there to pick up my categories from Customer table.

    Obviously, I would be able to eliminate the need of this difficult logic by simply creating 3 PBI dashboards, but I would prefer to have my data in 1 place.

     

    Thanks

    rszirmai