Percentage Variance on Rows total in a Matrix

[dustdaniel]

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.

[Greg_Deckler]

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

Thank you @Greg_Deckler 

Could you guide me here on how to do it?

Attached is my sample file

[Greg_Deckler · Accepted solution]

@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