cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Rankx for Pareto issue

Hi all,

I don't know what to do anymore, I've tryied all the hints I found on the web.

I'm trying to create a rank measure for days periods, which will be used to create a Pareto chart. But when I using a RANKX function it shows me only 1's.

 

Below are data that I have:

murban_1-1599202165299.png

 

Days Period = Text field

TotalAmount = SUM('JIRA all'[Count]) ==> Count is a column with "1" for each row

RankingMeasure = RANKX(ALL('JIRA all'[Count]),[TotalAmount])

 

Will be very grateful for you help! 🙂

 

 

5 REPLIES 5
Community Support
Community Support

Hi @murban 

 

would you like to get this one?

Measure = RANKX(ALL('Table'),[TotalAmount],,DESC,Dense)

0000.PNG 

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

Hi,

Unfortunatly it still not working 😕

murban_0-1599547686489.png

 

Hi @murban 

 

You might consider providing your dummy pbix that would be helpful for us to investigate it further. 

You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Super User IV
Super User IV

@murban , measure rank is context-sensitive . It will only give proper rank for 'JIRA all'[Count]

 

You need take column include the column in all which you need in rank

example

City Rank = RANKX(all(Geography[City]),[Sales]) //does not work with city id, other two did
Geography Rank = RANKX(all(Geography),[Sales])
City and ID Rank = RANKX(all(Geography[City],Geography[City Id]),[Sales])

 

 

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi Amitchandak,

I have tried to perform this function by the ways given in the links (I even renamed the columns so as not to make a mistake) but the result is still the same:

murban_0-1599204435722.png

murban_1-1599204507825.png

murban_2-1599204525030.png

Do you have any other advice?

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors