Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
Let's imagine we have fact tables with 100k sales. There is 20k of dictinct customers and they could buy stuff with delivery to home or without.
Should I create a dim table where I would put an information with my customers and type of delivery?
Or maybe that info should stay in fact table because of the high caridnality?
Thank you in adnvance!
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-a.... 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/
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |