Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi all,
I have this table:
Company Count Rank
A 23 1
B 10 2
C 5 3
D 2 4
And with this DAX code works just fine
Company Count Country Rank
A 23 US 1
B 10 UK 2
C 5 AUS 1
D 2 ARG 4
How i should develop this my DAX code in order to obtain a Rank like mas first table above.?
Best
Solved! Go to Solution.
Hello all,
Finally i've solved that way:
Hello Ibendlin,
Company and Country: Columns
Count and Rank: Measures
Best
Hello all,
Finally i've solved that way:
** EDIT: I realize this doesnt exactly answer your question, but this may help someone else stumbling upon this post 🙂
You could try making a string concatenation of the two Rank Columns, then sort those alphabetically.
Is "Count" a column or a measure? Do you want the rank as a column or as a measure?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
3 | |
3 | |
3 | |
3 |