Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I finally found how to create a cumulative total measure, but now I'm running into the problem of the cumulative total changing when I filter to see certain dates.
I want the cumulative total to always start from 0, or the first production date, but still be able to only view specific points in time.
For example when I view only 2023- the cumulative total starts from January 2023, not the first production date back in 2019. The Date column used below is essentially record date.
Right now my measure is this:
@sboobar You can do this using Better Running Total, using CALCULATE in a single table data model is going to give you wonky results a lot of times. Better Running Total - Microsoft Power BI Community
You *might* be able to get there switching your ALLSELECTED to ALL
I was able to create the cumulative (or running total) without 'calculate' but I still have the same issues when it comes to viewing/filtering to specific time periods- my measure changes its cumulative total depending on the dates I have selected. The measure I used is below:
This worked in SQL using Spotfire, just trying to find DAX equivalent for Power BI
Sum([GrossWaterProd]) over (Intersect([PropNum],AllPrevious([Date])))
Example of cumulative total changing:
Location with 2023 selected:
Location with 2022-2023 selected:
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
122 | |
109 | |
60 | |
55 |