Learn DAX in Toronto!

Costs of Relationships in DAX

SalesHeaderDetails-Schema

The relationships in a data model queried by DAX are a fundamental part of the engine and simplify the query itself. This article examines the cost of relationships in a data model, providing hints to optimize them.

Understanding ALLSELECTED

ALLSELECTED_ 01

ALLSELECTED looks like a special function that is able to understand what the user selected in the pivot table, retrieving the original filter context under which the pivot table is running. However, how it is possible that a DAX function knows what a user selected in a pivot table? If

Data Model Size with VertiPaq Analyzer

DMV Size 01

Analyzing table and column size is an important step in optimizing a data model for Power Pivot, Power BI, or Analysis Services Tabular. This article describes VertiPaq Analyzer, an Excel workbook to analyze detailed information extracted from Dynamic Management Views.


More articles



» ALL ARTICLES

Videos



» ALL VIDEOS

Connect with us







Next public conference

No upcoming events at the moment.