Rankx by group relational database DAX

[acatao]

I have one query called pivot which contains the following columns

Group Code (many)

Product Type (many)

Product Name (many)

Client Number (many)

Sales

I have a second query that pulls in information about the client with the following columns

Client Number(unique)

Manager Name

I have a one to many from client information to pivot using the client number.

I would like to create rankx in client information table based on Sales within a given Product Type

[Icey]

Hi @acatao ,

Please share us a dummy PBIX, removing sensitive information, for specific test.

It is suggested to upload your file to OneDrive for Business and then paste the link here.

Best Regards,

Icey

[amitchandak]

@acatao ,For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...