Forum Discussion
jamiefisher
1 year agoHelper I
Matrix Total Calculation
I have the following Matrix The columns 1 budget 2 comm 3 actual are all splits of one field. My table has rows of values and types, I am using the types to pull into these three categories. ...
Greg_Deckler
1 year agoCommunity Champion
jamiefisher OK, so are 1 Budget, 2 Comm, 3 Actual are those measures or are those values in a column?
I mean, in general you should be able to create a measure like the following:
Measure =
VAR __1 = SUMX( FILTER( 'Table'[Column] = "1 Budget" ), [Value] )
VAR __2 = SUMX( FILTER( 'Table'[Column] = "1 Budget" ), [Value] )
VAR __3 = SUMX( FILTER( 'Table'[Column] = "1 Budget" ), [Value] )
VAR __Result = __1 - __2 - __3
RETURN
__Result
Note, I am making assumptions about your data model because I don't know what it actually looks like.
jamiefisher
1 year agoHelper I
Hi sorry for not explaining this properly. I have deatiled table below and the visual outcome I am looking for. I do not have a value column for each type in the table so cannot find a way to create a formual to subtract one figure from another
| TABLE | |||||
| Subj | CC | Period | Tran Date | Financial Value | Balance Class |
| 020201 | 50300 | 11 | 27 Feb 2025 | 3270.74 | AB |
| 020201 | 50300 | 11 | 27 Feb 2025 | 3270.74 | AB |
| 020201 | 50300 | 11 | 27 Feb 2025 | -300000.00 | BX |
| 020201 | 50300 | 11 | 27 Feb 2025 | 3270.74 | AB |
| 020201 | 50300 | 11 | 27 Feb 2025 | 3436.55 | AB |
| 020201 | 50300 | 11 | 27 Feb 2025 | 3988.71 | AB |
| 020201 | 50300 | 11 | 27 Feb 2025 | 3988.71 | AB |
| 020201 | 50300 | 11 | 27 Feb 2025 | 351401.00 | BX |
| DESIRED VISUAL RESULT | |||||
| Row Labels | AB | BX | Variance | ||
| 020201 | 21226.19 | 51401.00 | 30174.81 | ||
| 50300 | 21226.19 | 51401.00 | 30174.81 | ||
| Grand Total | 21226.19 | 51401.00 | 30174.81 | ||