Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Dear ones, I am going around to solve this issue, I have no solicion, and in theory it is simple. I need to make a Ranking or a top of the best 10 Companies on a list, but I want the first position in all the reports to come out the company I am evaluating in the ranking in which it is located.
In the attachment I have the source data and the expected result.
https://drive.google.com/drive/folders/16KwdYP_8f_57tY1QDDPY4M6s7rlKtXBQ?usp=sharing
List
Expected Result
Thanks in advance for the support
Solved! Go to Solution.
Hi @Syndicate_Admin ,
In that case you will need two formula.
One for actual rank:
rank = RANKX('Table','Table'[Cap. Bursátil],,ASC)
One for the sort:
Column = IF('Table'[Empresa]="Nike Inc",0,'Table'[rank])
Then filter the column <=10.
Best Regards,
Jay
Thank you very much, I had not considered it as a column, I was taking it as a measure.
Hi @Syndicate_Admin ,
Check the measures.
_cap = SELECTEDVALUE('Table'[Cap. Bursátil])
rank = RANKX(ALL('Table'[Empresa]),[_cap],,ASC)
Measure = IF(SELECTEDVALUE('Table'[Empresa])="Nike Inc",0,[rank])
Best Regrads,
Jay
@Syndicate_Admin Seems like something like:
Ranking Final Column = IF([Empresa] = "Nike Inc", 1, [Ranking] + 1)
Thanks for the answer, but with what you indicate, I would show it in the first position with the value 1, and I need to know the actual ranking in which it is, but in position 1.
Hi @Syndicate_Admin ,
In that case you will need two formula.
One for actual rank:
rank = RANKX('Table','Table'[Cap. Bursátil],,ASC)
One for the sort:
Column = IF('Table'[Empresa]="Nike Inc",0,'Table'[rank])
Then filter the column <=10.
Best Regards,
Jay
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
84 | |
65 | |
62 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |