How to use rank functions that are not ranked by category

[Lopez0090]

I want to create a measure that is not ranked by category.

In the current measure, it is ranked like "Rank", but I want to rank it like "Rank I want".

▼Formula of the created measure

Total = SUM('Table 1'[Value])

Rank = RANKX(ALL('Table 1'[ID]),[Total],,,Dense)

▼Here are the data used and the actual visuals.

Thank you in advance.

[v-xiaotang]

Hi @Lopez0090 

Does the result you want?

If yes, use the two measures:

Total = SUM('Table'[Value])

Rank = RANKX(ALL('Table'),[Total],,,Dense)

See sample file attached bellow.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Lopez0090 , Try like

Rank = RANKX(ALL('Table 1'[ID], 'Table 1'[Category]),[Total],,,Dense)

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures