Subtraction between levels

[sergey_t]

Hi, 

I have table with several levels.

Is it possible to subtract from total value from column "B" every value from column "A" to get results as in column "C" with measure on all levels not only in totals?

 

[amitchandak · Accepted solution]

@sergey_t , Try  like a measure

calculate(sum(Table[A]), allexcept(Table[Level])) -calculate(sum(Table[A]), filter(Allselected, Table[Level] =max(Table[Level]) && Table[Level] =max(Table[Level])
&& Table[Level1] < max(Table[Level1] )))