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.
2 ACCEPTED SOLUTIONS
@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
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!
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-duplicate...
Cheers,
Nemanja Andic
