Forum Discussion

Berl21's avatar
Berl21
Helper III
3 years ago

Top N Filter doesn't work

Hi,

I have an issue with the Top N filter option on a visual. It simply doesn't interact with the table as intended.

Current status:


I need to see only the first row with MAX Value= 6. 

What are the typical reasons why this filter can't work properly? And if not possible to use it, what kind of measure can I write to replace it?

Thanks,

Pauline.

Need Help

3 Replies

  • meenakp's avatar
    meenakp
    Resolver I
    3 years ago

    Berl21, This could be a simple fix. After you select "TOP 1" there will be a "Apply filter". You have to click on it.

    In your case it will be just below "MAX Value" highlight you are showing here.

    • Berl21's avatar
      Berl21
      Helper III
      3 years ago

      meenakp Unfortunately it is already activated 😞 I don't get what could be in the way of this filter...

      I also tried to replace this filter with a simple measure that should report only the top cases when using a classic filter:

      Measure =


      IF([Max]=[Rank Stage MEASURE],1,0)

      I set the filter in this way:

      The problem with this is that it is not dynamic. "1" gets populated to the last entry, regardless of the time frame set in the slicer. 

      I need to replace this measure with a dynamic version of it, or fix the top n filter. 

      Do you have any ideas about this?

  • Berl21's avatar
    Berl21
    Helper III
    3 years ago

    meenakp I am still stuck with this issue.

    Here is my latest version:

    The filter is activated, the measure tie reports two distinct numbers. It should work but doesn't. Any idea why?