Forum Discussion
KPI Achieved Measure
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 , 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]))
4 Replies
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.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]))
Thanks very much. It's looks to have worked. Some issues on my side around duplicate entries.
