Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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 , 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.
@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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |