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 moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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 outstanding days.
Solved! Go to Solution.
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! 👏😊
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
21 | |
20 | |
20 | |
13 | |
13 |
User | Count |
---|---|
41 | |
28 | |
25 | |
23 | |
21 |