Solved: Re: RANKX no sequence

kasife · ‎04-02-2023

Hey guys.
Can anyone help me understand why my RANKX measurement is not getting sequential? I don't know that this displayed result is correct.

I am using the following measure:

Rank IPG = RANKX(ALL(Produtividade),[_IPG],,DESC,Dense)

amitchandak · ‎04-02-2023

@kasife , You can try Window as Rank- why and Why not: https://youtu.be/Pu8y8bd5mb8

But do not use it on large data

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

Ashish_Mathur · ‎04-02-2023

Hi,

Share the download link of the PBI file.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

amitchandak · ‎04-02-2023

@kasife , You can try Window as Rank- why and Why not: https://youtu.be/Pu8y8bd5mb8

But do not use it on large data

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

kasife · ‎04-08-2023

@amitchandak thank you so much

RANKX no sequence

Helpful resources

Fabric Community Update - November 2024

Be one of the first to start using Fabric Databases

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - November 2024

How to Get Your Question Answered Quickly

Be one of the first to start using Fabric Databases.