Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |