Forum Discussion
Helper IVNeed 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
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)
4 Replies
v-yulgu-msftMicrosoft Employee
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
AlexGallet01Hi 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.
- AlexGallet01
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)