Subtraction Formula

Hi rainchong7401 ,

 

Are you the maximum value minus all other values or from top to bottom, the last row of values minus all the values above?

In the first case, create a measure like this:

Subtract Formula = var _max=CALCULATE(MAX('Table'[Number]),ALLSELECTED('Table'))
var _total=_max*2-CALCULATE(SUM('Table'[Number]),ALLSELECTED('Table'))
return IF(ISINSCOPE('Table'[Number]),SUM('Table'[Number]),_total)

In the second case, you need to create an index column to get the value of the last row and subtract the other values.

Add the index column in Power Query.

Then create a measure.

Subtract Formula 2 = var _maxindex=CALCULATE(MAX('Table'[Index]),ALLSELECTED('Table'))
var _last=CALCULATE(SUM('Table'[Number]),FILTER(ALLSELECTED('Table'),[Index]=_maxindex))
return IF(ISINSCOPE('Table'[Number]),SUM('Table'[Number]),_last*2-CALCULATE(SUM('Table'[Number]),ALLSELECTED('Table')))

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.