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 want to know how to use DAX to rank like this?
Country | Customer | Sales Amount | Ranking |
CN | ABC | 200 | 4 |
CN | DEF | 100 | 5 |
CN | GHI | 300 | 3 |
CN | JLK | 400 | 2 |
CN | MNO | 500 | 1 |
US | ABC | 500 | 1 |
US | DEF | 400 | 2 |
US | GHI | 300 | 3 |
US | JLK | 200 | 4 |
US | MNO | 100 | 5 |
JP | ABC | 200 | 4 |
JP | DEF | 100 | 5 |
JP | GHI | 300 | 3 |
JP | JLK | 400 | 2 |
JP | MNO | 500 | 1 |
Also, is it possible to only show top 10 Country by their total "Sales Amount" and their Top 1 Customer by their "Sales Amount" in a single table?
Thanks
Solved! Go to Solution.
Hi, @KH_Mike
Thank you for your feedback.
Do you want to create a column or a measure?
My formula above is, as I already mentioned above, for creating a new column.
Please check the below for creating a new measure.
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, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @KH_Mike
Please check the below picture and the formula for creating a new column.
Ranking CC =
RANKX (
FILTER ( 'Table', 'Table'[Country] = EARLIER ( 'Table'[Country] ) ),
'Table'[Sales Amount],
,
DESC
)
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, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @Jihwan_Kim ,
Thank you for your support. However, when I apply it into my PBI, it show error and can't run correctly.
Hi, @KH_Mike
Thank you for your feedback.
Do you want to create a column or a measure?
My formula above is, as I already mentioned above, for creating a new column.
Please check the below for creating a new measure.
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, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |