Forum Discussion
Solved
Custom calculation for matrix row sub total
This is my table: and this is the matrix visual i have done: right now the Total row is just summing up all the rows but what i want is to add my own custom Total's rows to achieve s...
hi, thank you for your response, i have created the measure but it is showing the total productivity for 2024 only, in a new column.
I was wondering if it's possible to add it to the bottom of the matrix as the last row with the first column named: total followed by productivity 23 ,productivity 24 and var % value.
somthing like this:
i am using card visual to display the custom total values as of now.
danextian
Super User
Super UserHi rgoo ,
What measure did you write?
For Productivity 2023, you should be writing something like:
Productivity 23 (2) =
IF (
NOT ( HASONEVALUE ( 'table'[Office column] ) ),
[custom total measure],
[the measure used in productivity 23 column]
)
ahhh i created a new measure which led to a different outcome, i understand now. Thank you