In this tutorial, you’ll learn how to visualize the filter context in Power BI DAX Studio. Specifically, you’ll learn how to enable tooltips that show the active filter context of any cell in a table or matrix. A filter context reflects any active filter on a currently selected cell in Power BI. When you right-click
You might encounter issues with measures in Power BI table visualizations with a total row. The usual complaint is that the “Total” row is “incorrect” for the measure. Usually, the total row is correct for the measure, it’s just not what most people expect. In this tutorial, I’m going to take us through this common
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
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
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
