Quick Measure percentage difference gives wrong value

Hi MAAbdullah47,

I just verified that the formula works all fine with your shared sample data.

Avg price for 2016 = 219270 and for 2015 = 219058 so the equation should be

Diff = (219270 / 219058 ) - 1 = 0.1 %

Regards

Hi MAAbdullah47,

Based on my test, the formula below should work. :smileyhappy:

Diff = 
VAR currentYear =
    MAX ( 'saudisale_c'[d_year] )
VAR avgPricePY =
    CALCULATE (
        AVERAGE ( 'saudisale_c'[d_price] ),
        FILTER ( ALL(saudisale_c[d_year]), 'saudisale_c'[d_year] = currentYear - 1 )
    )
RETURN
    DIVIDE ( AVERAGE ( 'saudisale_c'[d_price] ) - avgPricePY, avgPricePY )

Regards