I currently have a data model showing some sales for each country by Customer. We have decided to highlight certain clients as ‘VIP’ clients for each respective country with a date period. The effect is when I select Country A, I only see the sales made by VIP clients in Country A (not interested in the non-VIP clients)
I am struggling with how to model this relationship - thinking of using an intermediary dimension table to track the VIP clients and link it between the customers (dimension) and sales (fact) table. However, I would need to create many unique column combinations to also link with country, date tables etc…
Data Model Example.pbix (71.0 KB)
Any suggestions will be greatly appreciated!