topic Re: Creating Ranks in DAX Commands and Tips

Creating Ranks

MNGoodyear — Tue, 11 Jun 2019 09:26:07 GMT

I have a table of all sales orders, including product group, order reference, order qty, customer, plus various other attributes.

I want to be able to create a report that summarises the order qty by customer and display the top 20 customers

I then want to apply a filter to change the product group

However i cannot seem to write the correct formula for establishing the rank.

Thanks

avanderschilden — Fri, 14 Jun 2019 09:42:20 GMT

Hello,

Are you sure you need a measure to get the desired result?

It is possible to display a dynamic TOPN in a visual that is influenced by slicers;

Anonymous — Tue, 04 Feb 2020 08:04:19 GMT

Hi, i am new in this community and still trying hard to navigate around.

i am trying to rank my supplier performance using the following DAX but the result still showing rank = 1.

Ranks = RANKX(ALL('NCR report'[Total NCR]), SUMX('NCR report', 'NCR report'[Total NCR]),,ASC)

please help..

Anonymous — Thu, 06 Aug 2020 08:48:38 GMT

HI Anonymous ,

You can create a RANKX Measure

Ranks = RANKX(ALL('NCR report'[Supplier]), [Total NCR],,ASC)

Regards,

Harsh Nathani