cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Subtract Column subtotals to each row value DAX

Hi All,

As the title suggest, I have this set of data with a simple total matrix

 Jan Feb March April May June July Total A 1 0 1 2 0 1 0 5 B 2 0 0 1 0 1 0 4 C 1 2 0 1 0 1 0 5

Is it possible to get the value of ONLY the column subtotals (5,4,5) and subtract them into each row value? I know I can define the total of the whole table with a Calculate(sum(cost),ALL(table)) Code. But I only want to get the subtotal value for each row.
The desired output is the one below:

 Jan Feb March April May June July Total A (5-1)4 (5-0)5 (5-1)4 (5-2)3 (5-0)5 (5-1)4 (5-0)5 5 B 2 4 4 3 4 3 4 4 C 4 3 5 4 5 4 5 5

Thanks!

Super User

@Anonymous , Assume you alreay using a measure M1, try one of the two

Diff = calculate([M1], removefilters(Table[Month]))

Diff =  calculate([M1], Filter(allselected(Table), Table[column] = max(Table[column])) )

Column is the column having A,b,C