Tag: dax filter context

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

Evaluation Context In Power BI DAX

In this post, I expand more on the evaluation context in Power BI DAX. You may watch the full video of this tutorial at the bottom of this blog. Evaluation context is also known as the initial context in Power BI. It is the environment from which your calculation is based on. To make things

Continue reading