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
Tag: dax filter context
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