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 level.  The "has breached" column is binary if the task breached it will show TRUE, if the task met deadline it will show FALSE.

 

CALCULATED COLUMNS

  • Count Deadline Met = COUNTAX(FILTER(task_detail,task_detail[has_breached]=FALSE()),TRUE())
  • Total Tasks = CALCULATE(COUNT(task_sla[TICKET_NUMBER]),ALL(task_sla[BREACH_STATUS]))
  • % of Deadline Tasks Met =  DIVIDE([Count Deadline Met],[Total Tasks],0)

 

Table 2 - Deadline Target

Second table shows details regarding the deadline targets.  It shows "task type" which is joined to the task detail table. This table also has Expected and Minimum % of Deadline Tasks Met. 

 

Example:

Task Type                |   Expectation   |   Minimum   |

Address Update     |         90%          |        85%      |

Phone Update        |         90%         |        85%      |

 

 

When I plug the fields into the KPI card, the percentage keeps showing 100% even though it is still showing correctly in the table format as shown in the screenshot below.  What am I missing?

 

 

 

 

 

 

  • 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.

     

6 Replies

  • 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

  • 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 

  • v-jialluo-msft's avatar
    v-jialluo-msft
    Icon for Community Support rankCommunity 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