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 ...
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.
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.