Forum Discussion
Incorrect Total
Hi, I am dealing with the common problem of not having my totals add up correctly and I am unsure how to amend it. Please see the measure below where I am trying to find the number of o...
Hi,
I think you want to wrap that measure in a SUMX iterating over the sales reps.
eg
SUMX(
VALUES(Table[Sales Reps]),
Your Measure
)
on rows where there is only one sales rep it returns the existing value. On the total row it adds up each in turn.
Hi,
I think you want to wrap that measure in a SUMX iterating over the sales reps.
eg
SUMX(
VALUES(Table[Sales Reps]),
Your Measure
)
on rows where there is only one sales rep it returns the existing value. On the total row it adds up each in turn.
Hi bcdobbs ,
Thanks alot. You've helped me figure out what was missing! You're amazing, have a great day! 👏😊