Clear amounts or compensate amounts with added conditions

[jlafran]

Hi, I need to clear the amounts whitch conjunctionally eliminate each other, like 5 and -5, also i need to respect if they are either Manzana(Apples) or Pera (Pear), and also it needs to respect this conditions: AB=CD, YU=HR, AB=YU .

The resultant columns should be:

Which are the values that didn´t conjunctionally eliminate each other.

Thanks.

[amitchandak]

@jlafran ,

Try a formula like

sumx(table, if(isblank([Neted]) ,[value], blank()))

or

sumx(values(table[group]), if(isblank([Neted]) ,[value], blank()))

or

sumx(values(table[group]), if(isblank(sum(Table[Neted])) ,Sum(Table[value]), blank()))

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[jlafran]

Hi,  @amitchandak. I´m really sorry if i wasn´t clear in my initial explanation. I edited my original post, i hope now it´s clearer. Thank you very much.