If the natural data can't support the sorting and filtering requirements, you might need to add an index column and sort by it.

The new Microsoft Excel Visual Calculations feature in Power BI simplifies the process of creating DAX measures by allowing users to directly reference fields in their visuals.