Top 3 and Bottom 3 Measure

[AI14]

Hi,

how can i get the Top3 and Bottom 3 for the following code:

H Count Breach > =

COUNTX (

    FILTER ( vw_CLEANING__ST, [Historic Countall] = "1" ),

    [H breach >]

)

This code shows the number of times a staff member has breached and would subsequently show the total number next to their name in a table.

I would like the top 3 or bottom 3 to show in table or a multicard.

John	4
James	6
Mike	8

[johnt75 · Accepted solution]

You can use the filter pane for this. Select the visual and then for the name column choose TopN filtering. You can select either top or bottom 3 and use your measure as the value.