Forum Discussion
Matrix Column Totals alternatives
HLST
The "total" doesn't really mean sum up the values, it is just a label that display of the aggregation of visual value. For example, if I want it to be AVERAGE, I can create an measure = average([value]), and change the label from "Total" to "Average" under the "subtotals" section in the format panel. This also applies to variance, mean, median, etc. You need to create an appropriate measure and change the label accordingly.Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Super UserHLST ,isinscope can help
I think you need use column on column of matrix
If(isinscope(Table[COlumn]), [Budget], [Variance])
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/