Forum Discussion
Subtraction between levels
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?
Anonymous , 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] )))
1 Reply
- amitchandak
Super User
Anonymous , 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] )))