Why I don't get TOP N option in my filter type? I only got "is less than" option.

[greatestbuying]

Hi,

I want to get the TOP N option in my filter, but I only have the "is less than" option and it greyed out also, I can't select anything. Please check the picture. 

many thanks.

[v-binbinyu-msft]

Hi @greatestbuying ,

In Power BI, measure will calculate in context and return a scalar value, so you could not apply Top N for it, but you could apply Top N to field and sort by the measure.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[paladin21 · Accepted solution]

Probably because "Total Profit" is a measure. To get Top N you need a regular category and then you get to choose the measure or agreggation you want to have the data selected from. In your case, you should have the filter in "First EnglishProducts" and use "Total Profit" as the measure.

[greatestbuying]

thanks for ur replay. You are right, Total profit is measure, I use this measure as filter, it doesn't give me Top N option. But I use another measure Top order as filter, I got Top N option. I don't understand the difference.