Tag: FILTER DAX

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

Advanced DAX Functions: Calculating Profit Contribution

In this blog, I’ll be discussing some more advanced DAX functions to demonstrate what’s possible in Power BI. You may watch the full video of this tutorial at the bottom of this blog. This tutorial will teach you how to visualize the profit contribution of different client tiers using advanced DAX functions. Calculating Total Profits

Continue reading

Dynamically Calculate A Power BI Running Total Or Cumulative Total

The Power BI running total is the perfect way to display patterns and changes on a specified data over time. In Power BI, there is a common combination of DAX functions that allow us to create a dynamic cumulative total on any report page. The DAX formula that we’re about to discuss is easy to

Continue reading