Issue while applying filter tmy matrix visual

[Sumo82]

Iam  facing an issue  while applying the  filter to  my matrix  visual .

For eg  if iapply the  filter  to show top 10  restaurants wiht the highest  ratings in a country .The  matrix visual still show more than  10 restaurant  with high ratings .Can you let me know what am  I missing here?  Screenshots attached.

[nandic · Accepted solution]

@Sumo82 it is expected behaviour as all these have same rating.
It can't get random top 10 if there are more than 10 restaurants with same rating.

If you still want to add some more conditions to it, there is very similar topic on this link with valuable answers: https://community.fabric.microsoft.com/t5/Desktop/Workaround-to-show-TOP-N-where-there-are-duplicate...

Cheers,
Nemanja Andic

[Uzi2019 · Accepted solution]

Hi @Sumo82 

Sum Amount = SUM ( Table[rating] )

Top N = CALCULATE ( [Sum Amount], KEEPFILTERS ( TOPN ( 3, ALL ( table[resturant] ), [Sum Amount], DESC ) )  )

https://community.fabric.microsoft.com/t5/Desktop/Top-N-with-duplicates-clarification/m-p/130620#M55...

https://community.fabric.microsoft.com/t5/Desktop/Top-N-displaying-more-than-N-when-duplicate-values...

Refer above blogs for better understanding this behaviour.

I hope I answered your question!

[nandic · Accepted solution]

@Sumo82 it is expected behaviour as all these have same rating.
It can't get random top 10 if there are more than 10 restaurants with same rating.

If you still want to add some more conditions to it, there is very similar topic on this link with valuable answers: https://community.fabric.microsoft.com/t5/Desktop/Workaround-to-show-TOP-N-where-there-are-duplicate...

Cheers,
Nemanja Andic