Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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! 🙂
Hi @Anonymous
would you like to get this one?
Measure = RANKX(ALL('Table'),[TotalAmount],,DESC,Dense)
Hi,
Unfortunatly it still not working 😕
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.
@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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |