Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

TOPN Visual level filter

When I am applying a TOP 5 visual level filter am getting 7 values, I think its due to the measure having same values,

so how to show TOP 5 values, it should not be hardcoded, even if i select 10 items in Scenario name slicer, it should show only top 5 among them

 

 

 
Need Help
Show and Tell

2 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Anonymous ,

     

    Click on filter property of that table --> Select ScenarioName --> Filter Type to Top N --> Enter 5 in Show Items value --> By Value option drag your TNR field.

     

    Dont forget to hit THUMBS UP and Accept this as a solution if it helps you!

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ，

     

    Please try this measure:

    Rank = 
RANKX(
    ALLSELECTED(Sheet1),
    FIRSTNONBLANK(Sheet1[TNR], 1),
     ,
     ASC,
     Dense
)

     

     

     

    Best regards,
    Lionel Chen

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.