sum by category

[pani_victoria]

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?

[amitchandak · Accepted solution]

@pani_victoria , I think you should return the revenue, I think you do not need step result

[pani_victoria]

Guys, you are geniuses!

Thanks a lot!

[Ahmedx · Accepted solution]

create two measures like this

m1 =
DIVIDE(sum('database' [Target Rev]), COUNTROWS('database'), BLANKO)


Target Revenue= 
SUMX(VALUES('database'[Branch]), [m1])

[amitchandak · Accepted solution]

@pani_victoria , I think you should return the revenue, I think you do not need step result