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 Friends,
I have issue with RANKX
When I have table only with Customer Name and RANKX formula everything works well.
But when i'm adding addinional context (Company Type, Domain ) RANKX does not work properly.
Could you please help?
Thanks in advance!
Regards,
Oleh
Solved! Go to Solution.
Hi @Anonymous
I made some changes to your model.
1. Changed the relationship direction and type
2. Rank Measure - it needs to be ALL( Account[Account] ) not ALL( Revenue [Account] )
3. In your visuals use the fields from the Account table, not from Revenue
Please see the attached file.
Refer
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
Hi @Anonymous
If you are trying to rank over the columns you are adding then you will need to include these columns in the first argument of rankx ALL( column1, column2, column3 ).
If you are looking for a different outcome then please can you provide a data sample and an outcome expected.
Hi @Anonymous
I made some changes to your model.
1. Changed the relationship direction and type
2. Rank Measure - it needs to be ALL( Account[Account] ) not ALL( Revenue [Account] )
3. In your visuals use the fields from the Account table, not from Revenue
Please see the attached file.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |