Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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(Sales/Calls) when I apply filter context.
These are the results for the two models in July, being:
% CONVERSION URU = CALCULATE(DIVIDE([Sales URU],[Calls URU]),ALLSELECTED(Uruguay[modelo]))
What "% AVG URU" is doing is (0,31+0,42)/2 = 0,36 but what i expect to do is:
(0,95+0,71+0,63+0,34+0,2+...+0,04)/10 = 0,32
Thank you so much!
Model 1
DECIL | CALLS | SALES | SALES/CALLS |
10 | 78496 | 528 | 0.67% |
9 | 76428 | 306 | 0.4% |
8 | |||
7 | |||
6 | ... | ... | ... |
5 | ... | ... | ... |
4 | |||
3 | |||
2 | ... | ... | ... |
1 | ... | ... | ... |
Model 2
DECIL | CALLS | SALES | SALES / CALLS |
10 | 16807 | 121 | 0.72% |
9 | 16500 | 91 | 0.55% |
8 | 16233 | 85 | 0.52% |
7 | ... | ... | ... |
6 | ... | ... | ... |
5 | ... | ... | ... |
4 | ... | ... | ... |
3 | ... | ... | ... |
2 | ... | ||
1 |
I have created a data segmentation that filter Model 1 and Model 2 and these are the result
DECIL | CALLS | SALES | SALES / CALLS |
10 | 95303 (78496+16807) | 649 (528+121) | 0.68% |
9 | 92928 | 399 | 0.43% |
8 | ... | ... | ... |
7 | ... | ... | ... |
6 | ... | ... | ... |
5 | |||
4 | |||
3 | |||
2 | |||
1 | ... | ... | ... |
I have created the next measure:
[AVG SALES/CALLS] =
[AVG SALES/CALLS] = DIVIDE(SUMX(TABLE,SALES),SUMX(TABLE,CALLS),0)
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!
[AVG SALES/CALLS] = AVERAGEX(DIVIDE(SUM(TABLE[SALES]),SUM(TABLE[CALLS]),0)
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
User | Count |
---|---|
83 | |
70 | |
69 | |
66 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |