Top 5 won't work when filter catergory selected

[Amos_Lim]

I have a chart that shows the top five.

When no filter is selected, it works flawlessly.

When a filter was applied, however, instead of showing the top 5, it displayed the top 6.

Please see below the 2 photos with and without filter selected.

How can I ensure that it never exceeds 5?

Need help! please. Thanks.

[Ashish_Mathur · Accepted solution]

Hi,

There is a tie at the 5th place - that's the reason you see 6 rows.  PBI file attached.

[Amos_Lim · Accepted solution]

Thank you so much, Ashish Mathur.

I tested it on more data sets and it seemed to work.

I'll run another test on my master file.

[Ashish_Mathur]

You are welcome.  Please mark my reply as Answer.

[Ashish_Mathur]

Hi,

Try these measure patterns

Count = counta(Data[Subsystem])

Top 5 = calculate([Count],Topn(5,all(Data[Area]),[Count]),values(Data[Area]))

Area is what i see in the legend of the pie chart.  Drag he Top 5 measure to the visual.

Hope this helps.

[Amos_Lim]

Hello, Ashish_Mathur.

I was able to get the first measure, Count = counta(Data[Subsystem]), to work.

In the second part, you mention noticing the "Area" in the pie chart's legend? There wasn't any Area in my chart. could you clarify?

[Ashish_Mathur]

I have assumed that AC,O,FS,DS are in the Area column of the Table.  chenge that accordingly to your data.

[Amos_Lim]

Yes, that was the subsystem, and I replaced both the count and the Top 5 with the following:-

Count = COUNTA('Data Master'[Subsystem])

Top 5 = CALCULATE([Count],TOPN(5,ALL('Data Master'[Subsystem]),[Count]),VALUES('Data Master'[Subsystem]))

I replaced the filters as shown below, but I still received the same result. Am I doing something wrong with the filters?

[Ashish_Mathur]

Clear the filter from the filter pane.  If it still does not help, then share the download link of the PBI file.  Show the problem there very clearly.

[Amos_Lim]

Hi Ashish Mathur,

Please see the sample file as attached.

Test Sample File 

[Ashish_Mathur · Accepted solution]

Hi,

There is a tie at the 5th place - that's the reason you see 6 rows.  PBI file attached.