Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Create measure with cumulative objectives

Hello,   I am trying to create a cumulative curve graph based on an annual goal calculated based on a number of employees. Each employee must have at least 3 interviews per year. For example, if ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello Aniya,

Thank you for your answer.

I've tried this solution but it doesn't works.

I'm not advanced on power Bi, that why so I have some questions that will seams easy for you.


1) Where did you save the json files ? The dataset with the objectives needs to be dynamic because it's related to the number of employees. nb of employees*2/12--> Do I need to create my own dataset ?  where shouldI save it ?

 

2) The measure doesn't show data. I had create the connexion between this table and the calendar table.

 

 

Thanks a lot for your help.

Best regards.

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello v-yueyunzh-msft ,

 

I am still working on the question I asked a few weeks ago. I'll try to be more clear with my request with this table.

 

I need  to create a cumulative column of monthly goals based on an annual goal, calculated as follows -> 

_Obj VPS Mensuel = DIVIDE([_Objectif_VPS],12,0) --> Which is the annual objectif I need to report by month

 

Each employee in the company should have one preventive visit per semester, or two per year.

Obj VPS Monthly :

 

the other colums are : 

_Total_Employés = COUNT('Liste du personnel'[N° d'empl.]) --> number of employees.
_Objectif_VPS = [_Total_Employés]*2  --> Each employees need to have a visite twice a year. 
_Obj VPS Mensuel = DIVIDE([_Objectif_VPS],12,0) --> Which is the annual objectif I need to report by month.
 
I need this data to create a line chart with cumulatve objectives.

 

This is what I currently get on Power BI : 

 

 

I also tried to transform the yearly goal by month with the created table but without success :

 

 

Thanks a lot for your help.