Top 10 Companies + My Company

[Syndicate_Admin]

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

[Syndicate_Admin]

Thank you very much, I had not considered it as a column, I was taking it as a measure.

[v-jayw-msft]

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

[Greg_Deckler]

@Syndicate_Admin Seems like something like:

Ranking Final Column = IF([Empresa] = "Nike Inc", 1, [Ranking] + 1)

[Syndicate_Admin]

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.

[v-jayw-msft · Accepted 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