Forum Discussion
Solved
Percentage Variance on Rows total in a Matrix
Hi there, I was requested in a matrix to show the % variance from 2025 vs 2024 instead of the sum as a total. Is this possible? Consider that all the values in the columns are measures. ...
dustdaniel Well, not much information to go on so not sure how specific and accurate I can be but let's say you have a measure called "Dias", you could create the following measure and use it in your visualization instead:
Dias Total = VAR __Dias = [Dias] VAR __Dias2025 = CALCULATE( [Dias], 'Dates'[Year] = 2025 ) VAR __Dias2024 = CALCULATE( [Dias], 'Dates'[Year] = 2024 ) VAR __Result = IF( HASONEVALUE( 'Dates'[Year] ), __Dias, __Dias2025 - __Dias2024 ) RETURN __Result
dustdaniel So yes. You could add a check in your measure formulas to check if there is a single value for Year. If not, then you are in a Total row and you can determine what to do from there. For example.
dustdaniel Well, not much information to go on so not sure how specific and accurate I can be but let's say you have a measure called "Dias", you could create the following measure and use it in your visualization instead:
Dias Total = VAR __Dias = [Dias] VAR __Dias2025 = CALCULATE( [Dias], 'Dates'[Year] = 2025 ) VAR __Dias2024 = CALCULATE( [Dias], 'Dates'[Year] = 2024 ) VAR __Result = IF( HASONEVALUE( 'Dates'[Year] ), __Dias, __Dias2025 - __Dias2024 ) RETURN __Result
