Tag: dax filter context

Filter In Power BI: DAX Queries Context Transition

By Nick Mone, Enterprise DNA Expert on June 22, 2021June 21, 2021

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

Posted in: dax filter context, filter context, FILTER DAX, Optimization techniques, Power BI Optimization, xmSQL statement

Power BI

Evaluation Context In Power BI DAX

By Sam McKay, CFA on November 18, 2020July 20, 2021

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