Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

DAX Ranking

‎05-13-2021 02:03 PM

Hello,

 

I have a following scenario

 

achillies21_1-1620939496512.png

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

Labels:
Message 1 of 7
2,016 Views
0
1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

‎05-18-2021 01:22 AM

Hi @Anonymous ,

 

Check the formula.

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

1.PNG

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

Message 7 of 7
1,866 Views
6 REPLIES 6
v-jayw-msft
Community Support
Community Support

‎05-18-2021 01:22 AM

Hi @Anonymous ,

 

Check the formula.

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

1.PNG

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.
Message 7 of 7
1,867 Views
Ashish_Mathur
Super User
Super User

‎05-13-2021 05:29 PM

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Message 6 of 7
1,918 Views
0
Anonymous
Not applicable

‎05-13-2021 05:22 PM

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

Message 5 of 7
1,932 Views
0
Anonymous
Not applicable

‎05-13-2021 05:17 PM

Hi,

 

I am looking for a calcualted column

Message 3 of 7
1,948 Views
0
Ashish_Mathur
Super User
Super User
In response to Anonymous

‎05-13-2021 05:20 PM

Hi,

Share the download link of your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Message 4 of 7
1,940 Views
0
Ashish_Mathur
Super User
Super User

‎05-13-2021 05:14 PM

Hi,

Should this be a calculated column formula or a measure?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Message 2 of 7
1,958 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

View All