Forum Discussion

AI14's avatar
AI14
Icon for Helper III rankHelper III
3 years ago
Solved

Top 3 and Bottom 3 Measure

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
James6
Mike8
  • johnt75's avatar
    johnt75
    3 years ago

    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.

1 Reply

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    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.