Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Sumo82
Regular Visitor

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 still show more than  10 restaurant  with high ratings .Can you let me know what am  I missing here?  Screenshots attached.scn shot 1.pngScn shot 2.png

2 ACCEPTED SOLUTIONS
nandic
Memorable Member
Memorable Member

@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

View solution in original post

Uzi2019
Super User
Super User

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!

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

View solution in original post

2 REPLIES 2
Uzi2019
Super User
Super User

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!

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
nandic
Memorable Member
Memorable Member

@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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.