Ben Richardson gets back to basics:
Sometimes the culprit isn’t actually your DAX, it’s your data model.
Star schema mistakes are incredibly common in Power BI, and really hard to track down.
When your data model isn’t a clean star schema, you end up with broken filters, confusing relationships and slow visuals.
It’s important to get it right from the start! So we broke down the top 10 most common mistakes people make, how to identify them and how to fix them!
This is where reviewing (or reading) Ralph Kimball’s Data Warehouse Toolkit can save you a lot of time and stress. The Microsoft data analytics world is predicated so heavily on Kimball-style dimensional modeling that the choices tend to be building a proper star schema up-front or spend processing and developer time trying to fix it in post-production using DAX or trickery.