Top N with conditions

[dw700d]

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

[dw700d]

Thank you all for you the input.

[ryan_mayu]

@dw700d

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)

[lnz]

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.

[Anonymous · Accepted 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