Should I create a dim table?

Anonymous 

Normally I would advise you to create a dim table, so that you do not repeat customer information unnecessarily in a fact table. Due to the high cardinality, it is now difficult to estimate whether it will actually have a positive result (or maybe even a negative one). That's why I advise you to install DAX Studio. This is a free tool that gives you insight into information related to your data model. See how your data model looks now, and how it looks after you've created a dim table, via the Vertipaq Analyzer option (link showing you more info about this: https://www.fourmoo.com/2020/11/11/how-to-use-vertipaq-analyzer-with-dax-studio-for-power-bi-model-analysis/). This allows you to clearly see what the effect is, and depending on that you can actually implement it or not. Download DAX Studio from this link: https://daxstudio.org/