KPI Achieved Measure

[24601]

Hi

I am looking to create a measure that will allow me to see an KPI Achieved figure based on the following sample data. I have previously used a calculated column with an IF statement to give me 1 or 0 and then used a measure of that to get the average but I would like to remove the need for a calculated column if possible.

The below shows items for sale and the number of days taken from purchase to sale. For the KPI to be achieved the Days Taken must be lower than the Target Days. There will be multiple KPIs not just the one shown below. 

I need this to be able to be rolled up into monthly, quarterly, yearly, by sales person etc for performance management. 

Any help would be greatly apprecaited. If you need clarification please let me know. 

Thank you

[24601]

Thanks @amitchandak 

I'm getting an error for the countx

[amitchandak · Accepted solution]

@24601 , My mistake , try this one

divide(Sumx(summarize(Table, Table[KPI], Table[Item#], Table[Start Date], "_1", [Achieved]),[_1]), countx(summarize(Table, Table[KPI], Table[Item#], Table[Start Date]),[KPI]))

[24601]

Thanks very much. It's looks to have worked. Some issues on my side around duplicate entries. 

[amitchandak]

@24601 , Assume achcieved measure like

Achieved = if(sum(Table[days taken]) <=Sum(Table[Target]), 1, 0)

Achieved% measure

Achieved % =
divide(Sumx(summarize(Table, Table[KPI], Table[Item#], Table[Start Date], "_1", [Achieved]),[_1]), countx(summarize(Table, Table[KPI], Table[Item#], Table[Start Date])))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.