Forum Discussion
Solved
Issue while applying filter tmy matrix visual
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 stil...
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 AndicHi 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!