topic Re: KPI "Value" Incorrect in DAX Commands and Tips

KPI "Value" Incorrect

Anonymous — Thu, 01 Dec 2022 22:43:47 GMT

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?

Re: KPI "Value" Incorrect

v-jialluo-msft — Fri, 02 Dec 2022 09:21:40 GMT

^{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}

Re: KPI "Value" Incorrect

Anonymous — Fri, 02 Dec 2022 20:15:38 GMT

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

Re: KPI "Value" Incorrect

v-jialluo-msft — Mon, 05 Dec 2022 02:59:02 GMT

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

Re: KPI "Value" Incorrect

Anonymous — Mon, 05 Dec 2022 17:33:42 GMT

Apologies, can you try this? I am unable to include attachments on my posts in this thread for some reason.

https://drive.google.com/drive/folders/1DY5-qNXJzGMnjC90pFOaOs2pHX57xDfH?usp=sharing

Re: KPI "Value" Incorrect

v-jialluo-msft — Tue, 06 Dec 2022 03:22:09 GMT

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.

Re: KPI "Value" Incorrect

Anonymous — Fri, 09 Dec 2022 16:35:18 GMT

Hi Gallen,

This worked, thank you so much!

-Amanda