Forum Discussion
Different KPI Targets depending on the client
I'm trying to figure out the best approach so we have 6 different KPI measures in different tables but the targets could differ depending on the client and the KPI.
So as an example...
KPI 1 for client x could be a 90% target but for client y it could be a 95% target
KPI 2 for cleint x could be a 90% target but for client y it could be a 97% target
Thanks
With no sample data, tables, relationships or any DAX code, it is not possible to say. But as a generic rule, IF the value changes for each client and for each KPI, then the best approach is to store it in a table. A simple table structure will be like.
KPI Client Value KPI 1 X 95% KPI 1 Y 96% KPI 2 X 97% KPI 2 Y 98% Then use this as a reference table in your calculations to pick up the relevant value for each KPI & Client.
3 Replies
- amitchandak
Super User
Anonymous , Try something like this
switch( true(),
max(client[client]) = "A", sum(Table[Target])*.97,
max(client[client]) = "B", sum(Table[Target])*.95,
sum(Table[Target])) With no sample data, tables, relationships or any DAX code, it is not possible to say. But as a generic rule, IF the value changes for each client and for each KPI, then the best approach is to store it in a table. A simple table structure will be like.
KPI Client Value KPI 1 X 95% KPI 1 Y 96% KPI 2 X 97% KPI 2 Y 98% Then use this as a reference table in your calculations to pick up the relevant value for each KPI & Client.
