Total

Hi mmowrey 

First you have to create a measure to perform different calculations for column values and total. Below is an example. In this example, [Year] column is placed on Column of a matrix visual. For every year, it calculates the sum of sales in that year. For the total, it calculates the % difference between two years. 

% difference = 
IF(
    ISFILTERED('Table'[Year]), // Identify whether it is on column or on total
    SUM('Table'[Sales]), // This is the calculation for years on column
    // Below is the calculation for total
    var _2024 = CALCULATE(SUM('Table'[Sales]),'Table'[Year]=2024)
    var _2023 = CALCULATE(SUM('Table'[Sales]),'Table'[Year]=2023)
    return
    DIVIDE(_2024-_2023,_2023)
)

As the sum of sales and % difference have different formats, you need to set a dynamic format for this measure. You can use this for the format

IF(ISFILTERED('Table'[Year]),"0.00;-0.00;0.00","0.00%;-0.00%;0.00%")

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!