How To sort by 2 Columns, One ASC and the other DESC

martins.vanags · January 14, 2020, 8:02am

Hi,

Try this formula when creating a new calculated measure:

    Cast([Sprint].CurrentMember.Name as string)||" - "||
Cast(
Rank(
[Sprint].CurrentMember,
Order(
[Sprint].[Sprint].Members,
[Measures].[Sprint end date],
BASC
)
)as string)

Then sort your report by this new calculated measure in descending order.
Finally, you could click on the column and remove it. The sorting must remain in the report

Martins / eazyBI team