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.