cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nganbla
Helper II
Helper II

Matrix table with top 10 but show more than 10

i have a pending issue and could not solve by myself.

 

laggers.jpg

 

as above matrix table, I showed customers, this month and same period month (last year). %delta sales (use measure).

I config to show top 10 based on %delta from bottom only.

but you can see it's show more than 10, it's show 15 customer because we have some same %deta value at ( 2 x 92.86%,  2 x 87.50%...)

 

the idea I want to show only 10. 

 

how can i config it?

2 REPLIES 2
v-jayw-msft
Community Support
Community Support

Hi @nganbla ,

 

Did amitchandak formula works for you?

According to your screenshot, you have 6 x -66.67% records, which record you want to show in top 10 records?

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
amitchandak
Super User
Super User

@nganbla , In rank add Rand()/100

and then filter for TOP N Rank

 

New Rank = RankX(all(Table[Col]),[Measure]) + Rand()/100 

 

Top 10 = CALCULATE([Measure],TOPN(10,all(Table[Col]),[New Rank],ASC),VALUES(Table[Col]))

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!