Tag: filter context

Power BI Filters: Invoking Context Transitions

Power BI Filters: Invoking Context Transitions

This tutorial will discuss about Power BI filters. You’ll learn how to see context transition in the xmSQL and the logical query plan. The context transition transforms the current row context into an equivalent filter context. The filters are then triggered by the CALCULATE function. The Importance Of The CALCULATE Function The CALCULATE function creates

Continue reading

DAX Calculation – Filter Context Transitions

DAX Calculation – Filter Context Transitions

In this tutorial, you’ll learn about how the storage engine can use the data model to compute information for your DAX calculation. It has the ability to use Left Outer Joins via the data model. The storage engine can do simple joins by having a one-to-many relationship in your data model or by using the

Continue reading

Filter In Power BI: DAX Queries Context Transition

Filter In Power BI: DAX Queries Context Transition

This post will discuss how to identify a filter via xmSQL and the storage engine query in Power BI. You’ll also learn what VertiPaq is doing when you filter on range. This is an important topic because the cardinality of what’s being applied in the filters is the biggest driving force of DAX’s performance. xmSQL

Continue reading

Understanding Power BI Aggregations

Now, let’s delve deeper into one of the most important concepts in Power BI calculations — the aggregations. Power BI aggregations are formulas used to calculate a single summarized value from multiple rows that are grouped together. There are different ways to create aggregations in Power BI. Some of the examples of aggregation functions are

Continue reading

The Difference Between ALL And ALLSELECTED DAX Functions In Power BI

The Difference Between ALL And ALLSELECTED DAX Functions In Power BI

The difference between ALL and ALLSELECTED DAX functions can be relatively confusing when you’re starting out with Power BI. In this tutorial, I’ll quickly go over the main differences between those two commonly used DAX functions and their respective usages in your Power BI reports. You may watch the full video of this tutorial at

Continue reading