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.
Go to Solution.
I think you want to wrap that measure in a SUMX iterating over the sales reps.
on rows where there is only one sales rep it returns the existing value. On the total row it adds up each in turn.
View solution in original post
Hi @bcdobbs ,
Thanks alot. You've helped me figure out what was missing! You're amazing, have a great day! 👏😊
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.