Top N Filter doesn't work

[Berl21]

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.

[Berl21]

@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?

[meenakp]

@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]

@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?