Forum Discussion

Vanessa250919's avatar
Vanessa250919
Icon for Helper V rankHelper V
5 years ago
Solved

% Difference with Flag

Hello Community,   I'm newbie in Dax, I need a formula to calculate % difference between SUM (NB_PARCELS ) and SUM( FLAG Reg), it's possible ?     
Need Help
  • ERD's avatar
    ERD
    5 years ago

    Hi Vanessa250919 ,

    Do the calculation, then display values as percenatges:

     

     

ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Vanessa250919 ,

Do the calculation, then display values as percenatges:

 

 

  • Vanessa250919's avatar
    Vanessa250919
    Icon for Helper V rankHelper V
    5 years ago

    I try but in % is not correct 

     

     

  • ERD's avatar
    ERD
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Measure 3 = [Measure2] / [Measure1]

    and then display values as percenatges.

  • Vanessa250919's avatar
    Vanessa250919
    Icon for Helper V rankHelper V
    5 years ago

    Ok my fault 

     

    Measure = CALCULATE(SUM(VOL_DISTRI[Flag REG])/SUM(VOL_DISTRI[SUM(NB_PARCELS)]))
     
    IT's Ok Now Thanks !