cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dw700d Frequent Visitor
Frequent Visitor

Top N with conditions

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% EnrollmentCalls Handled
123%150
213%200
314%180
4100%1
514%150
60%0
70%4
811%124
919%145
1027%203
111%10
12100%2
130%0
14100%4
150%0
1 ACCEPTED SOLUTION

Accepted Solutions
Chiara Regular Visitor
Regular Visitor

Re: Top N with conditions

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

View solution in original post

4 REPLIES 4
Chiara Regular Visitor
Regular Visitor

Re: Top N with conditions

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

View solution in original post

lnz Frequent Visitor
Frequent Visitor

Re: Top N with conditions

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.

ryan_mayu Established Member
Established Member

Re: Top N with conditions

@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)

c1.JPG

 

dw700d Frequent Visitor
Frequent Visitor

Re: Top N with conditions

Thank you all for you the input.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors