Introduction CALCULATE/CALCULATETABLE are the most important functions in DAX, and the only ones that are capable of modifying the original filter context. CALCULATE has a few rules you need to follow, and they aren’t that hard to understand. The complexity comes when those rules interfere with each other or with the original filter context. Original …
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. …
Explanation When we talk about filtering directions, we are referring to the arrows in the relationships. The way they are pointing is the way the filters can move through the data model. Most of the time you will have a single way of filtering data, and that is from 1 to many side of the …
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 …
This section will explain why you would need a data model (having all the data in a single table is never a good practice), and the differences between dimension and fact tables. We will start this section first by understanding the most important data modeling rules, and those are the distinction between the filter and …
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 …
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 …
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 …
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 …
Explanation Grouping table functions have only one purpose, and that is to create a distinct combination of columns/tables supplied. Grouping functions are mostly used as intermediate steps in DAX code. Most use cases: Create a set of values on a higher granularity which you need to iterate upon eq. Find the best-selling product in each …
EXCEED Solutions d.o.o.
Drežnička 21, 10000 Zagreb, Hrvatska
OIB: 25417969805
MBS: 081124327
IBAN: HR6523600001102641074
info@exceed.hr
+385 98 9461 471
Ured: Modruška 2, 10000 Zagreb
Designed and powered by Adssential
