DAX to Subtract a row from the row total to get variance

[NumbersAndStuff]

Hi,

assuming my data is summed in a matrix as follows:

columnA

1

2

3

4

-----

10

Question:

how do I subtract the values from the total to determine variance of column A's total into a new columnB 

ie:

ColumnA. | columnB

1.                       9

2.                       8

3.                       7

4.                       6

----------------------

10.                    30

[VishalJhaveri]

I created the table "testTable" with a single column, "A".
 

Plotted this column in the matrix visual.

Measure to build column B =

CALCULATE(

    SUM(TestTable[A]),

    ALL(TestTable[A])

    )

    -

    CALCULATE(SUM(TestTable[A]))

Plotted this measure in the matrix table.

I hope this solution helps.

Thank you.

[NumbersAndStuff]

Hi, thanks for the help! I'm still having some issues and want to clarify it a little more. ColumnA is a measure which is:

Avg = calculate(sum('dw factsalesorders'[Sales])/calculate(sum('dw factsalesorders'[qty])))

when I try to do this it's not working correctly:

vari=calculate(sum('dw. Factsalesorders'[sales])/calculate(sum('dw factsalesorders'[qty])),all('dw factsalesorders'))-calculate(sum('dw factsalesorders'[sales])/calculate(sum('dw factsalesorders'[qty])))

it changes all values in the matrix and isn't correct...what am I doing wrong :)?

[NumbersAndStuff]

 

[VishalJhaveri]

Can you please share the file using ONEDRIVE Link? @NumbersAndStuff