Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

KPI "Value" Incorrect

Hi There,  I am trying to create a KPI card and having a heck of a time getting it to display properly.    Table 1 - Task Detail First table has information related to tasks on an individual leve...
  • v-jialluo-msft's avatar
    v-jialluo-msft
    3 years ago

    Hi  Anonymous ,

     

    Please follow these steps:
    (1) Create new measure

    goal = CALCULATE(MAX(sla[Expectation]),ALLSELECTED('task'))

Value = 
SUMX(SUMMARIZE(ALLSELECTED('task'),[Expectation],"1",DIVIDE([Count SLA Met],[Total Tasks],0)),[1])


    (2)Final output

     

    Best Regards,
    Gallen Luo
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-jialluo-msft's avatar
v-jialluo-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi  Anonymous ,

 

Please follow these steps:
(1) Create new measure

goal = CALCULATE(MAX(sla[Expectation]),ALLSELECTED('task'))

Value = 
SUMX(SUMMARIZE(ALLSELECTED('task'),[Expectation],"1",DIVIDE([Count SLA Met],[Total Tasks],0)),[1])


(2)Final output

 

Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Gallen, 

    This worked, thank you so much! 

    -Amanda