Forum Discussion
Solved
Weight Average using subtotal
Dear Communitiy I am trying to calculate a weighted average using a Sales Persons results only. In the image below I explain what I am trying to achieve. The columns in greens should be = [Appl...
HI Anno2019
I will assume that Apple Sales is a measure
Then for the total per sales person = CALCULATE ( [Apple Sales], ALLEXCEPT ( Sales, Sales[Sales Person] ) )ofcourse you need first to decide if the sales person sells to different countries what should be the logic? Would you consider each country seperately or as a whole?
HI Anno2019
I will assume that Apple Sales is a measure
Then for the total per sales person = CALCULATE ( [Apple Sales], ALLEXCEPT ( Sales, Sales[Sales Person] ) )
ofcourse you need first to decide if the sales person sells to different countries what should be the logic? Would you consider each country seperately or as a whole?
