Forum Discussion

clem312's avatar
clem312
Resolver I
4 years ago
Solved

Percentage difference

Hi everyone,   I am trying to make a difference between 2 percentages for 2 different years. My formula doesn't work : Significance = ABS(CALCULATE([Measure], FILTER(Q74a, Q74a[Annee_lib]=2020))...
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi clem312 

     

    What is the formula for [Measure]? Can you share it as well as some sample data?

     

    Maybe you can try this formula:

     

    Significance =
    ABS (
    CALCULATE (
    [Measure],
    ALLEXCEPT ( Q74a, Q74a[matrix row field name] ),
    Q74a[Annee_lib] = 2020
    )
    - CALCULATE (
    [Measure],
    ALLEXCEPT ( Q74a, Q74a[matrix row field name] ),
    Q74a[Annee_lib] = 2019
    )
    )

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.