Forum Discussion

AlexGallet01's avatar
AlexGallet01
Icon for Helper IV rankHelper IV
8 years ago
Solved

Need help for calcul

Hello,   I need help for do a calculate in a new measure. I want to calculate a percentage between two result in a table (Montant € & Objectif CA) to do a conditionnal fitness.   Thank you  
Need Help
  • AlexGallet01's avatar
    AlexGallet01
    8 years ago

    Hi,

     

    It's ok. I found a solution. I do 2 measures, one for calculate the sum of the Montant € and one for Objectif CA. Next i do calculation between these measurements.

     

    Measure 1 -> Somme MT CA/MOIS = CALCULATE(SUM(Factures[Montant €]))

     

    Measure 2 -> Somme Obj CA/MOIS = CALCULATE(SUM('Objectifs CA'[Objectif CA]))

     

    Measure -> % CA realise = IF([Somme Obj CA/MOIS]<>0;([Somme MT CA/MOIS]/[Somme Obj CA/MOIS]) ;0)

AlexGallet01's avatar
AlexGallet01
Icon for Helper IV rankHelper IV
8 years ago

Hi,

 

It's ok. I found a solution. I do 2 measures, one for calculate the sum of the Montant € and one for Objectif CA. Next i do calculation between these measurements.

 

Measure 1 -> Somme MT CA/MOIS = CALCULATE(SUM(Factures[Montant €]))

 

Measure 2 -> Somme Obj CA/MOIS = CALCULATE(SUM('Objectifs CA'[Objectif CA]))

 

Measure -> % CA realise = IF([Somme Obj CA/MOIS]<>0;([Somme MT CA/MOIS]/[Somme Obj CA/MOIS]) ;0)