Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |