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 ,

 

According to your description, your question is that the value in the KPI visuals is not consistent with the correct value in the table.

There may be no constraints in the KPI visuals, which is different from the value environment in the table.

You can try to add a slicer to select the corresponding Task.

If it doesn't solve your question, please upload a sample file to further solve the question.

 

Best Regards,

Gallen Luo

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Gallen v-jialluo-msft ,

    I did filter the KPI Card for the specific task but am still getting an incorrect value percentage in the KPI card.  Please see the sample file attached here. 

    Thanks so much.

    Amanda

     

    LINK TO SAMPLE FILE: PowerBI File