DAX Ranking

[Anonymous]

Hello,

I have a following scenario

I would like to rank based on the Priority. For example, all the promotions, products with highest priority (for example 2) should get first rank and the subsequent less order priority should 2nd rank and so on...

Please provide suggestions.

Thanks

[Anonymous · Accepted solution]

Hi @Anonymous ,

Check the formula.

Column = RANKX('Table','Table'[priority],,DESC,Dense)

Best Regards,

Jay

[Ashish_Mathur]

Hi,

Try this calculated column formula

=calculate(distinctcount(Data[Priority]),filter(data,data[promotion]=earlier(data[promotion])&&data[priority]>=earlier(data[priority])))

Hope this helps.

[Anonymous]

I am sorry it can't be shared as it has business data

[Anonymous]

Hi,

I am looking for a calcualted column

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.

[Ashish_Mathur]

Hi,

Should this be a calculated column formula or a measure?