Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
how do you calculate the the ID who had Accepted the most number of calls (without knowing). So in the example, the mode ID is 1 because it acccepted 2 calls (more than any other ID) and rejected 2 calls and cancelled 1 call, meaning that they had 5 call transactions. So their call acceptance would be 2/5 or 40%. Any suggestions on a calculated measure?
Hi@ puj831
You can try these two measures as below:
Everyone call acceptance:
Measure = var tmp =SUMMARIZE(Table2,Table2[ID],"Acc",CALCULATE(SUM(Table2[Accepted])),"totalCall",CALCULATE(SUM(Table2[Accepted])+SUM(Table2[Cancelled])+SUM(Table2[Rejected])),"Per",CALCULATE(SUM(Table2[Accepted]))/CALCULATE(SUM(Table2[Accepted])+SUM(Table2[Cancelled])+SUM(Table2[Rejected]))) return var MaxAcc=MAXX(tmp,[Acc]) return SUMX(filter(tmp,MAX([Acc])=MaxAcc),[Per])
Most call accepted :
Measure 4 = var maxValueID = CALCULATE(maxx(TOPN(1, SUMMARIZE('Table2', Table2[ID]), [Measure], DESC), [id]), all(Table2)) return if(min(Table2[ID]) = maxValueID, [Measure], BLANK())
Then drag filed ID and measure 4 into table visual
Result:
Here is Demo, please try it
https://www.dropbox.com/s/dkr3po7b7cd3i34/mode%20stats.pbix?dl=0
Best Regards,
Lin
Hi@ puj831
You can try to use measure as below:
Measure 3 = CALCULATE(SUM(Table1[Accepted]))/CALCULATE(SUM(Table1[Accepted])+SUM(Table1[Cancelled])+SUM(Table1[Rejected]))
Result:
Best Regards,
Lin
Thanks, however, how can I get it to show only 0.40, not the others. So it would be the the ID that has the most acceptances only. thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |