Sort by column turning total blank

[NitzanMalka]

Hi, I have a table that I added to mu data so I can get a total row

the measur calculat is: 

mesur = IF(SELECTEDVALUE('NewTableMarket-Total'[Market])="Total",CALCULATE((SUM('ForecastUnion'[ForecastAccuracyCase])-(SUM(SalesUnion[CrtQty])))*(-1),ALL('NewTableMarket-Total'[Market])),(SUM('ForecastUnion'[ForecastAccuracyCase])-(SUM(SalesUnion[CrtQty])))*(-1))

so far so good, the problem is when I'm updating the market to sort by the index column

when I'm doing so it's shows blank on the total

Market order by market

Market order by index

Thanks in advance!

[amitchandak]

@NitzanMalka , Try like

mesur = IF(SELECTEDVALUE('NewTableMarket-Total'[Market])="Total",CALCULATE((SUM('ForecastUnion'[ForecastAccuracyCase])-(SUM(SalesUnion[CrtQty])))*(-1),ALL('NewTableMarket-Total')),(SUM('ForecastUnion'[ForecastAccuracyCase])-(SUM(SalesUnion[CrtQty])))*(-1))