Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 = [Apples Sales]/[Subtotal Peter Parker], I am not sure how to do this in DAX.
Solved! Go to Solution.
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?
You rule! It works! I will take other countries into consideration later.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |