Forum Discussion
pani_victoria
Helper III
Helper IIIsum by category
Colleagues, hello!
I need your help! My result is wrong!
I have data with sales by date and monthly sales plan in each line for each manager.
But when I summarize the employee plan for the branch, I get the wrong total and I don’t know where to look for the error.
Correct result 637169!
My data
Please tell me how to fix this?
pani_victoria , I think you should return the revenue, I think you do not need step result
create two measures like this
m1 = DIVIDE(sum('database' [Target Rev]), COUNTROWS('database'), BLANKO) Target Revenue= SUMX(VALUES('database'[Branch]), [m1])
3 Replies
- amitchandak
Super User
pani_victoria , I think you should return the revenue, I think you do not need step result
- Ahmedx
create two measures like this
m1 = DIVIDE(sum('database' [Target Rev]), COUNTROWS('database'), BLANKO) Target Revenue= SUMX(VALUES('database'[Branch]), [m1]) - pani_victoria
Guys, you are geniuses!
Thanks a lot!
