Forum Discussion
Calculate Average with Filter Context
Hi, i have a problem that i can´t solve. I have the results of machine learning's models, divided by month and decil. What i am trying to do is to calculate the average conversion rate(...
Thank you for your response. However, I´m not getting the desired result.
With your measure, what i get is this
| DECIL | CALLS | SALES | SALES/CALLS |
10 | 95303(78496+16807) | 649(528+121) | 0.68% |
| 9 | 92928 | 399 | 0.43% |
| 8 | 89916 | 360 | 0.4% |
| 7 | 85753 | 233 | 0.27% |
| 6 | 79370 | 199 | 0.25% |
| 5 | 71424 | 188 | 0.26% |
| 4 | 17771 | 68 | 0.38% |
| 3 | 20885 | 69 | 0.33% |
| 2 | 22536 | 65 | 0.29% |
| 1 | 24100 | 51 | 0.21% |
[AVG SALES/CALLS] = (649+399+...)/(95303+...24100) = 0.38%
What i want to get...
[AVG SALES/CALLS] = (0.68%+0.43%+0.4%+...+0.21%)/10 = 0.35%
Thank you!
lbendlin
Super User
Super User[AVG SALES/CALLS] = AVERAGEX(DIVIDE(SUM(TABLE[SALES]),SUM(TABLE[CALLS]),0)