Forum Discussion
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.
Thanks for the guidance.
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
3 Replies
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
