Forum Discussion
Solved
Average Sales per Sales Rep
Hey guys, hopefully this is just a simple DAX question: Let's assume we have two tables. One with all Sales Reps: Rep ID | Name 1 | Greg 2 | Susan ... and another...
ok, so found the solution myself. In case you want to know:
Define a measure that calculates the sales made per period:
# Sales = CALCULATE( COUNTROWS(sales), FILTER(sales, [Date] >= MIN(calendar[Date]) && [Date] <= MAX(calendar[Date]) ) )Then define a new measure for the average. I was interested in not only the average, but the median:
Median # Sales per Rep = CALCULATE( AVERAGEX/MEDIANX(sales, [# Sales]), FILTER(reps, [Rep ID] > 0 )
)Maybe this helps someone.
Best,
Sebastian
ankitpatira is there no way doing this calculation via a measure?
ok, so found the solution myself. In case you want to know:
Define a measure that calculates the sales made per period:
# Sales =
CALCULATE(
COUNTROWS(sales),
FILTER(sales,
[Date] >= MIN(calendar[Date]) &&
[Date] <= MAX(calendar[Date])
)
)Then define a new measure for the average. I was interested in not only the average, but the median:
Median # Sales per Rep =
CALCULATE(
AVERAGEX/MEDIANX(sales, [# Sales]),
FILTER(reps,
[Rep ID] > 0
)
)
Maybe this helps someone.
Best,
Sebastian