Showing results for 
Search instead for 
Did you mean: 
New Member

Should I create a dim table?



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!

Solution Sage
Solution Sage


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: 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: 

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors