Forum Discussion
Issue while applying filter tmy matrix visual
- 2 years ago
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-duplicates/td-p/2276772
Cheers,
Nemanja Andic - 2 years ago
Hi Sumo82
Sum Amount = SUM ( Table[rating] ) Top N = CALCULATE ( [Sum Amount], KEEPFILTERS ( TOPN ( 3, ALL ( table[resturant] ), [Sum Amount], DESC ) ) )Refer above blogs for better understanding this behaviour.
I hope I answered your question!
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-duplicates/td-p/2276772
Cheers,
Nemanja Andic