Forum Discussion

NitzanMalka's avatar
NitzanMalka
Regular Visitor
3 years ago

Sort by column turning total blank

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!

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    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))