Value by Week Measure KPI

Question

Hi all,&nbsp;I believe this dilemma is solvable by DAX, but I don't have enough experience to solve it myself.&nbsp;We have data that comes in by date, item, and scheduled and produced amounts. If an item is over or under-produced, it does not meet the KPI (between 95% and 105%).&nbsp;In simplest terms, I need a measure which will compare the number of items which made KPI by week by the total number of items worked on by week.&nbsp;Here is a sample table:Item123A&nbsp;123B&nbsp;123C&nbsp;WeekProduction AccuracyKPI MetProd. Acc.KPI MetProd. Acc.KPI Met194%No (0)90%No (0)101%Yes (1)2104%Yes (1)95%Yes (1)102%Yes (1)399%Yes (1)&nbsp;&nbsp;103%Yes (1)Total99%66% (2/3)92.5%&nbsp;50% (1/2)102%100% (3/3)&nbsp;Total KPI Met for above table: 6 met over 8 overall, 6/8, 75%.&nbsp;Getting the production accuracy measure was pretty simple, but getting the KPI Met measure has proved tricky since it has to remain consistent when being rolled up to month, year, and a lot of different categories (work station, item category, etc).&nbsp;If more clarification is needed please let me know. Thank you.

mahoneypat · Answer

It would be better to share your example table and an example of correct results.&nbsp; Here is a measure expression pattern that may work.
&nbsp;
Avg&nbsp;Weekly&nbsp;KP&nbsp;Met&nbsp;=VAR&nbsp;vSummary&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;ADDCOLUMNS&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DISTINCT&nbsp;(&nbsp;Date[Week]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"cCount",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COUNTROWS&nbsp;(&nbsp;Table&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"cKPIMet",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COUNTROWS&nbsp;(&nbsp;Table&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Table[Scheduled],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Table[Produced]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Table[Produced]&nbsp;&gt;=&nbsp;0.95&nbsp;*&nbsp;Table[Scheduled]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;Table[Produced]&nbsp;&lt;=&nbsp;1.05&nbsp;*&nbsp;Table[Scheduled]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;)RETURN&nbsp;&nbsp;&nbsp;&nbsp;AVERAGEX&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;vSummary,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[cKPIMet]&nbsp;/&nbsp;[cCount]&nbsp;&nbsp;&nbsp;&nbsp;)
&nbsp;
Pat

Forum Discussion

Value by Week Measure KPI

1 Reply

Related content

Week over week measure

Measure returning incorrect value

Blank columns when doing Measure Name Measure Value approach

Curren week measure

Calculate previous week values

Item	123A		123B		123C
Week	Production Accuracy	KPI Met	Prod. Acc.	KPI Met	Prod. Acc.	KPI Met
1	94%	No (0)	90%	No (0)	101%	Yes (1)
2	104%	Yes (1)	95%	Yes (1)	102%	Yes (1)
3	99%	Yes (1)			103%	Yes (1)
Total	99%	66% (2/3)	92.5%	50% (1/2)	102%	100% (3/3)