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 v-yulgu-msft,

 

My calcul is ((Montant € / Objectif CA) * 100)

 

I put you an exemple of my table with an exemple value because it's confidential.

 

 

Regards

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

Hi v-yulgu-msft

 

I forgot to tell you the value of Montant € is in table Commande and the value  of Objectif CA is in table Objectif CA so when i want calulate this percentage i have a access problem at data.