How to Sort Numerical Measure having text data type

[HarshuGangurde]

Hello All,
Kindly help me on below issue.
I want to sort this measure by ASC or DESC order but the problem is that measure having text datatype because of decimal formatting.
How can we solve this problem?
LY Actual Value_L3 = var _format= CALCULATE([Actual Value],FILTER('Master Calendar','Master Calendar'[IS Last Fiscal Year]="Yes"))+0 return FORMAT(_format, SWITCH( SELECTEDVALUE('Number Format'[Decimal Place],"#,#0.00"), 0,"#,#0", 1,"#,#0.0", 2,"#,#0.00", 3,"#,#0.000" ) )

[PC2790]

Hey @HarshuGangurde ,

You can try and sort it by another column which is Number by using Sort by Column.

To do this select your measure in the fields list and then on the Modeling Tab select Sort by Column and select the Number Field.

[MahyarTF]

Hi,

Would you please share a sample data,

I created the sample data for my self, and it is worked :

[HarshuGangurde]

Hello,

Could you please share your sample data.

Thanks.

[MahyarTF]

I put as a screen shot in my previous post