Forum Discussion

pani_victoria's avatar
pani_victoria
Icon for Helper III rankHelper III
2 years ago
Solved

sum 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,...
Need Help
Show and Tell
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    2 years ago

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

  • Ahmedx's avatar
    Ahmedx
    2 years ago

    create two measures like this

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


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

     

pani_victoria's avatar
pani_victoria
Icon for Helper III rankHelper III
2 years ago

Guys, you are geniuses!

Thanks a lot!