Topic: DAX
-
This article describes the improved server timings features in DAX Studio 2.17 to analyze the parallelism of storage engine operations. Read more
-
In one of the Advanced DAX Workshop I taught this year, I had an interesting discussion about how to optimize a SWITCH statement (which could be frequently used checking a slicer, like in the Parameter Table pattern ). Let’s start with the problem. What Read more
-
The calculation for ABC analysis can be made in PowerPivot using calculated columns. In this way each row can have an attribute with the appropriate ABC class. The ABC calculation has to be made considering a particular grouping and sort order. For example, Read more
-
Explore the differences between GENERATE and CROSSJOIN while discovering different solutions to solve a business problem described during the Guy in a Cube Q&A Live of October 9, 2021. The question was how to match employees with skills at a… Watch now
-
This article describes what limited relationships are and the differences between regular and limited relationship in Power BI and DAX. 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 how to control format strings in calculation groups. Before starting, we suggest you read the previous articles in this series. Read more
-
In DAX, optimizations and data types do not always play nice and can leave you dealing with surprises. In this short article, we see an example of how mixing blanks, Boolean logic, and comparison with TRUE might lead to unexpected… Read more
-
This article describes how to customize the drillthrough experience in Excel PivotTables connected to Power BI datasets or Analysis Services databases. 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
