Rankx for Pareto issue

[Anonymous]

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:

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! 🙂

[v-diye-msft]

Hi @Anonymous 

would you like to get this one?

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

 

[Anonymous]

Hi,

Unfortunatly it still not working 😕

[v-diye-msft]

Hi @Anonymous 

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.

[amitchandak]

@Anonymous , 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/367415

[Anonymous]

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:

Do you have any other advice?