Forum Discussion

olsen9's avatar
olsen9
Frequent Visitor
3 years ago
Solved

Creating a RowNum but Sorted by Field

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

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

General Comment
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.