Creating a RowNum but Sorted by Field

[olsen9]

RowNum = 
CALCULATE (
    COUNT ( 'Table'[ID] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[ID]  <= MAX ( 'Table'[ID]  )
    )
)

Where can I add in sort by field in this equation? 

[Anonymous · Accepted solution]

Hi @olsen9 ,

I think [RowNum] should be a measure based on your calculation logic. As far as I know, Power BI doesn't support us to add a measure to sort the columns.

For reference: 

Sort one column by another column in Power BI

Here I suggest you to create a Custom column in Power Query Editor and then use this function. If you sort a column by a calculated column which is calculated based on that column, Power BI will return a circule error.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.