Dan: 8. kolovoza 2022.

DAX HANDBOOK
5.4 Propagation

Filter propagation represents the ability of filters to flow through the data model.When we talk about filter propagation in a data model, there is only one consideration we need to consider, and that is whether we are in a row or filter context. If we are in a filter context, all filter propagations happen automatically. …

DAX HANDBOOK
5.4 Propagation
Read More »

DAX HANDBOOK
5.2. Relationships

Relationships are like bridges between our tables. Without them, our model would consist of isolated “islands” of data, having no direct relationships with each other. Relationships are one of the most important building blocks of the data model. You won’t define them often. Most of the time you will set relationships the moment you import …

DAX HANDBOOK
5.2. Relationships
Read More »

DAX HANDBOOK
5. Data Model

The backbone of every good and fast DAX calculation is a well-defined data model. What is a Data Model? In simple terms, the data model consists of all the tables in your Power BI/Excel/analysis services database that are connected through relationships. The definition also includes other, non-related tables, as well as other objects in the …

DAX HANDBOOK
5. Data Model
Read More »

DAX HANDBOOK
4.4 Table to Scalar Transformation

Explanation All table functions have one special feature. If the result of the table function returns exactly one row and a single column, its result is automatically transformed into a scalar which can be shown in a visual. The [NumberOfCategories] is a measure that counts the number of unique CategoryNames from the Sales table, taking …

DAX HANDBOOK
4.4 Table to Scalar Transformation
Read More »

DAX HANDBOOK
4.3 Mixed functions

Explanation Mixed functions are the ones that can form group-by of multiple columns and define different data granularities while having the ability to invoke row context over the newly formed tables. The most important one is SUMMARIZE. SUMMARIZE is mostly used as a replacement for VALUES function when we need to create crossjoin of multiple …

DAX HANDBOOK
4.3 Mixed functions
Read More »

DAX HANDBOOK
4.2 Iterative Table functions

Iterative Table Functions Overview In our previous article, we saw that grouping table functions have one main purpose. That is to group values from columns supplied as arguments into a single table on the granularity defined by the group-by operation. We refer to Group-by as the table created upon grouping columns from the source table …

DAX HANDBOOK
4.2 Iterative Table functions
Read More »

Scroll to Top