Top5 values with more repeated values

[Jan845]

Hi Sirs,

I create a TOP N with my ROOM column to show in one card the Name of the room that have more values repetead and i need other card to count the number of them but shows wrong values.

And i can't create a top 5 chart with top 5 of the rooms that repeat more times in the column when i selected filter PORTO show more than top 5 values and if i unselect the Porto filter shows only top 5 values...

My Table:

ROOMLOCALNUMBER OF REQUESTTYPE

123	Lisboa	31270	OTHERS
132	Lisboa	16970	ACCESS
132	Porto	31972	SUPPORT
132	Porto	30565	Internet
134	Lisboa	32851	COMPUTER
134	Lisboa	29716	INTERNET
134	Lisboa	19056	PROJECTION
135	Lisboa	60503	CAMERA
135	Lisboa	30206	PROJECTION
144	Lisboa	22865	CAMERA
EAA003	Porto	32891	Zoom
EAA005	Porto	21342	PROJECTION
EBI011	Porto	32858	PROJECTION
EBI017	Porto	31173	PROJECTION
EC015	Porto	32889	CAMERA
EC112	Porto	30735	COMPUTER
EP002	Porto	32890	PROJECTION
EP004	Porto	22846	OTHERS
ER207	Porto	29254	PROJECTION
Room 11	Lisboa	19848	ACCESS
Room 1221	Lisboa	23288	INTERNET
Room 11	Lisboa	22518	OTHERS
Room 11	Lisboa	22519	PROJECTION
Room 1221	Lisboa	32484	CAMERA
Room 1221	Porto	18458	CAMERA

My PBIX file: WeTransfer - Send Large Files & Share Photos Online - Up to 2GB Free

Thanks for your help

[Anonymous]

Hi @Jan845 ,

The screenshot is too small to see.

Can you share the expected result as well?

Best Regards,

Jay

[Jan845]

Without a filter 

With Filter Porto dont show top 5 values

And i have TOPN higer 5 with count room