Total

[mmowrey]

How would i go about create a % differnce between the 2 years instead of the total that shows?

[Anonymous · Accepted solution]

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!

[Greg_Deckler]

@mmowrey First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8