Top N Filter gives more than N despite no ties

[djansson]

I am trying to show the Top 3 courses by F% in my report, but it keeps giving me far more than the top 3 even though there are no (relevant) ties for the information. Here's what I'm seeing:

For the record, no matter what I put for N, it always shows me more results than I'm asking for.

[djansson · Accepted solution]

Thanks for responding.

I think I figured it out on my own. It looks like one of the calculated columns used in [F%] was using BLANK if there was no data, which was screwing up the % calculations and was probably therefore screwing up how PBI calculates Top N. I simply added "+ 0" to the calculated column so that it returns 0 instead of blank, and it looks like that fixed it.

[PijushRoy]

Hi @djansson 

If it is solved, please mark this post as solved

[v-kkf-msft]

Hi @djansson ,

I could not reproduce your question, could you please share your sample data or PBIX file?

Best Regards,
Winniz