Hello,
New Measure in Power BI provides a simple way to create measures, including a running total.
However, when I try to use that option, it requires a field. I'm simply trying to have it give me a running total of this Contribution Percent column, but it requires I choose a field to reset it by. I don't want to. I just want it to use the filters in the Matrix table.
I've tried using a DAX formula, but can't figure out how. I've re-watched several of the PowerPivot tutorials to see if that would help, but I can't see anything that applies to this.
(I'm thinking Contribution Percent / (Contribution Percent... above this line). I've been at this for nearly 3 hours, I've tried Bard, ChatGPT, and Aria and they just run around in circles. I'm trying to figure this out myself, but I'm out of ideas.
Any help would be greatly appreciated.
Hi Nate,
The running total measure, like ANY measure, will need a field from a data table. You can't use filters for running totals or any measure.
Thanks. Does that mean that any time I am going to want a running total, I need to add a column in Power Query with the field that I'll want to use instead of adding that as a Measure in Power BI?
No.
You have to answer a simple question: On what field you need the running total to be applied? That is the field you need to drag into the measure.
PBI does not know which column has the VALUES for the running total, it needs you to indicate that values column.
