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.
Good day all,
I am using the top n filter to show me the top 5 agents by % enrollments. The results however are misleading because the agents that appear in the top 5 have only taken 1 or 2 calls.
I would like to show the top 5 agents by % enrollment but I want to excluded agents that haven’t handled at least 100 calls. Is this possible?
Agent Id | % Enrollment | Calls Handled |
1 | 23% | 150 |
2 | 13% | 200 |
3 | 14% | 180 |
4 | 100% | 1 |
5 | 14% | 150 |
6 | 0% | 0 |
7 | 0% | 4 |
8 | 11% | 124 |
9 | 19% | 145 |
10 | 27% | 203 |
11 | 1% | 10 |
12 | 100% | 2 |
13 | 0% | 0 |
14 | 100% | 4 |
15 | 0% | 0 |
Solved! Go to Solution.
Hi,
is %enrollment a measure? or an attribute?
If it's a measure you can set the visual level filter :
Call Handled (Filter Type advanced filtering): show items when the value is greater than or equal 100
Agent ID (Top N); Top 5 By %enrollment
Thank you all for you the input.
I use DAX to create a new table to get your result. Plesae see if it works for you. Thanks.
Table 3 = VAR _table = FILTER('Sheet20','Sheet20'[calls]>100) RETURN TOPN(5,_table,Sheet20[%enrollment],DESC)
Proud to be a Super User!
You could add calculated column [Is in Top]
Is In Top = IF(Table1[% Enrollment] < 1 || Table1[Calls Handled] > 2; 1; 0)
Aftert that you have to add an filter on [Is In Top] = 1 at your visual or page and apply TopN filter on [% Enrollment].
P.S.
Here I add an addidittional condition on [Calls Handled] > 2, so if an employee handled more than 2 calls and have 100% enrollment, he will be considered in the rating.
Hi,
is %enrollment a measure? or an attribute?
If it's a measure you can set the visual level filter :
Call Handled (Filter Type advanced filtering): show items when the value is greater than or equal 100
Agent ID (Top N); Top 5 By %enrollment
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |