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)

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi AlexGallet01,

 

Would you please share sample data and desired output to illustarte your requirement more clearly? What are the two results you want to consider? And how to calculate the percentage conditionally? Please give more details.

 

Regards,

Yuliana Gu

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.