Need to restrict Table view for Top 10 Names

[harirao]

Hi Team,

Please assist me, I am working on a table were only top 10 names should be visible, based on a column call OPP ID which will be distinct, all the columns datatype is "Text"
Note: regarding Names column its from Master table, relationship created.


Thanks for your help in advance.

Regards,

[v-yiruan-msft]

Hi @harirao ,

Whether the problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with yours. Thank you.

On the other hand, you can share your sample pbix file with us for making troubleshooting.

Best Regards

[v-yiruan-msft]

Hi @harirao ,

According to your screenshot, it seems you are filtering the data with the below conditions:

1. RPTDATE is on 4/21/2021

2. Deal Churn Flag M is Pure Push Out

3.  Top 10 Customer Name according to Count of Opportunity_ID

Could you please check and confirm whether the filter setting and displaying data is correct or not?  However the table visual display the data from the field Custom Master, Deal Churn Flag M and Count of Opportunity_ID since the setting to filter Customer Name.... Thank you.

Best Regards

[amitchandak]

@harirao , Are you checking why there are more than 10 values?

This because of repetitive value

Refer how to break a tie in RANK
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/