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
Community Support
3 years ago

Hi  Anonymous ,

 

I tried to download the sample file, but it shows that I don't have permission to access. You need to remove the access restriction or upload it to the attachment so can download it.

 

 

Best Regards,
Gallen Luo