How would I have a stand alone column down from 1 2 3 etc to 20 This would tell what position a team

[Fedup]

The 1-20 would stay the same as each team goes up/down.

[v-prasare]

As we haven't heard back from you, we would like you to please share the sample PBIX file shown above? This will help in understanding your scenario and providing an accurate solution.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

[danextian · Accepted solution]

Hi @Fedup 

Try visual calculation

Row =
IF ( ISATLEVEL ( [Team] ), ROWNUMBER ( ORDERBY ( [Sum of Points], DESC ) ) )

Format the calculation to whole number

[Ashish_Mathur]

Hi,

This visual calcution measure works

S. No. with vis calc = if(ISATLEVEL([Presenter]),ROWNUMBER(ROWS,ORDERBY([Date Presented],ASC)))

Alternativel, this measure will work

S. No. = ROWNUMBER(ALLSELECTED(Data),ORDERBY(Data[Date Presented]))

Hope this helps.

[Royel]

Hi @Fedup  use this dax measure to get the correct order 

Position = 
RANKX(
    ALL(Team),
    CALCULATE(MAX(Team[Points])),
    ,
    DESC,
    DENSE
)

Results: 

Thanks 

[Fedup]

[Royel]

You need to create a measure and it should have correct Table and column name. Then use it in the table visual.

Create a measure: 

Select Table -> Right Click -> New Measure -> Pest the code 

Note: You can not directly run measure in DAX Query View, the format is littlebit different. 

Thanks

[cengizhanarslan]

You can use a visual calculation as below:

Rank = FORMAT ( RANKX ( ROWS, [Points], , DESC, Dense ), 0 )

or simply create a measure in your model as below and use it in your visual:

= RANKX ( ALLSELECTED ( DimTeam ), SUM ( [Points] ), , DESC, DENSE )

[KarinSzilagyi]

Hi @Fedup, you mean as a fixed index that shouldn't change as their ranking changes? 

If you don't have anything that you can order it by to maintain the order you predefined (e.g. not sorted by Name alphabetically) you can only really do this via Power Query Editor:

• Transform Data > Add Column > Index Column > From 0 / From 1 / Custom (depending on whether your index should start with 0, 1 or any other number you'd like to start with
  

[Zanqueta]

Hi @Fedup 

If you want the position to reflect the ranking based on Points (and optionally Goal Difference), use a calculated column or measure in DAX:

Position =
RANKX(
    ALL('Teams'),
    'Teams'[Points],
    ,
    DESC,
    DENSE
) 

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.