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 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