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

Should you use Import or DirectQuery data connectivity mode for your Power BI models? Let’s make the right choice by comparing the performance and scalability of the two options!  Watch now

This article shows how to use the USERELATIONSHIP function in DAX to change the active relationship in a CALCULATE function.  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 introduction of the weak relationships in Power BI composite models enables new data modeling techniques. However, not all of the many-to-many relationships can be managed by using weak relationship. The “classical” many-to-many relationships in data warehouse is a design…  Watch now

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

In the last few years, the Business Intelligence (BI) world has been moving towards self-service BI. As expected, several vendors created tools empowering regular users to gain insights from their data. Among the many, there is Power BI. Nowadays, users…  Read more

If you import more than one table into Power BI or Power Pivot, you have a data model. When you have more than one table, you usually have relationships between tables. When you analyze data, you often have many choices…  Read more