Tag: ALLSELECTED DAX

Using ALLEXCEPT To Stop The Cumulative Total From Resetting

I’m going to go through an interesting scenario that you’ll probably land on when you’re trying to run a Cumulative Total inside of Power BI. You may watch the full video of this tutorial at the bottom of this blog. A member from the Enterprise DNA support forum posted this query. The member wanted to calculate

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