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'[Forecas...
Need Help
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))