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!
@noobpowerbiuser , 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
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
105 | |
72 | |
68 | |
47 | |
47 |
User | Count |
---|---|
161 | |
85 | |
76 | |
68 | |
67 |