Separate Negative and Possible value and make the right Sum on each measure

[ChiVi]

Hi everyone,

I have data set of Countries, Products, Supply and Demand value, I created a measure call " Supply Possibility"=Supply-Demand.

Then I want to separate negative and possible value into 2 measures and the right Sum will shown up in Total Row.

I already tried some suggestion to calculate the number but just show as attached picture with WRONG TOTAL, it should be something like BLUE and RED

SUMX(FILTER('Measures for all','Measures for all'[Supply possibility on BE (overall HB mix)]<0),[Supply possibility on BE (overall HB mix)])

Can you please help me with this? Thank you all.

[ChiVi]

Thanks a lot for your help @amitchandak . it works very well

[amitchandak · Accepted solution]

@ChiVi , Create a measure on top of your measure and use

Sumx(Sumamrize(Table, Table[Country], Table[Product], "_1", [Current Measure]), [_1])