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

5 Replies

  • ERD's avatar
    ERD
    Icon for Community Champion rankCommunity Champion
    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

      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 !