Forum Discussion
Cumulative Total- Total Value Does Not Match
Hello everyone,
I'm having trouble equaling the sum of a measure, 'YTD GM$', that collects the cumulative total of each value in the "Total GM$ Budget" by Week ID. The total values should be equal, however the last row, the measure does not spit a value.
Below is the measure I used to calculate the 'YTD GM$ Budget'. The 'Manager Calendar' is joined on the Week ID for Budget Table. I appreciate the help!!
HI cyncyn_98,
It sounds like a common measure total level calculate issue when you need to do multiple aggregates with these formulas.
If that is the case, I'd like to suggest you take a look at Greg's blog to know more about this and how to solve it:Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
1 Reply
HI cyncyn_98,
It sounds like a common measure total level calculate issue when you need to do multiple aggregates with these formulas.
If that is the case, I'd like to suggest you take a look at Greg's blog to know more about this and how to solve it:Measure Totals, The Final Word
Regards,
Xiaoxin Sheng