Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dw700d
Post Patron
Post Patron

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
Anonymous
Not applicable

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
dw700d
Post Patron
Post Patron

Thank you all for you the input.

ryan_mayu
Super User
Super User

@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

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




lnz
Frequent Visitor

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
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.