Need help for calcul

[AlexGallet01]

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

[AlexGallet01 · Accepted solution]

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]

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]

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]

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.