Data sorting issues in Power BI Designer based on Calculated columns

I have few fields that needs to be sorted based on some calculated columns and other fields. But it seems this works well in Excel Power Pivot but not in Designer sometimes. It displays command line ...