Topic: Modeling
-
This article analyzes a classic modeling question: is it better to build a model as a regular star schema or as a single table in Power BI? The answer is clear: a star schema is always the best choice. Read more
-
Don’t miss the upcoming free SQLBI live event on Friday April 16, 2021! Join Adam Saxton, Alberto Ferrari, Patrick LeBlanc, and Marco Russo to discuss common mistakes in big data models. Proper data modeling will be a hot topic in… Read more
-
This article explains the most common causes of the error, “A circular dependency was detected” in Power BI and Analysis Services. Read more
-
This article shows an optimized DAX technique to display the first N products for each category in Power BI, adding a row that aggregates the value for all the other products. The companion video introduces the scenario and the general… Read more
-
Power BI sets a new milestone in Business Intelligence: Marco describes the importance of new composite models in an article, and Alberto shows them in action in a video. Read more
-
This article introduces a technique to filter and productively compare two time periods with Power BI. Read more
-
Activating bidirectional cross-filter in a Tabular data model might create ambiguous paths in the chain of relationships, resulting in very dangerous models as numbers become unpredictable. This article provides a deep explanation of the kind of ambiguity that might appear… Read more
-
This article describes the types of relationships available in Power BI and Analysis Services, clarifying the differences in cardinality and filter propagation of physical relationships. Read more
-
This article describes what weak relationships are and the differences between strong and weak relationship in Power BI and DAX. Read more
-
The Detail Rows Expression in a Tabular model provides the user with control over the drillthrough results obtained by showing details of a measure. This article describes typical DAX expressions you can use in this property. Read more