Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |