cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yforti
Helper II
Helper II

Duplicate rankx values

Hi guys!

 

I'm having trouble creating a simple RankX measure, as I see that the formula does not contain any type of error, however, the rankx is not working.

I'm trying to rank by establishment (first column), an establishment is a hospital name and is formatted as text.

 

measures used:

Valor Alerta = CALCULATE(SUMX('visao_etapa_conta - Não Remetidas','visao_etapa_conta - Não Remetidas'[VL_CONTA]))
Rank Valor = RANKx(ALL('visao_etapa_conta - Não Remetidas'[ESTABELECIMENTO]),[Valor Alerta],,DESC)
 
 

 

yforti_0-1617217211833.png

 

9 REPLIES 9
Ashish_Mathur
Super User III
Super User III

Hi,

Do these measures work?

Valor Alerta = SUM('visao_etapa_conta - Não Remetidas'[VL_CONTA])
Rank Valor = RANKx(ALL('visao_etapa_conta - Não Remetidas'[ESTABELECIMENTO]),[Valor Alerta],,DESC)
If not, then share the download link of your PBI file.

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

Hi,

I tried but could not resolve the problem.  Sorry.


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

Hi, @yforti 

Please try using ALLSELECT, instead of ALL.

Or, if it is OK with you, please share your sample pbix file, then I can try to come up with a more accurate solution.

Thank you.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

How can i share my sample?

Jihwan_Kim
Community Champion
Community Champion

Hi,

you can save your file in Onedrive or Googledrive, and you can share the link here.

 


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

Jihwan_Kim
Community Champion
Community Champion

Hi, I think the file has been deleted.

Please check.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors