Forum Discussion
Responsive ResidentKpis modeling - general question
If the amount of KPI-target values are few there is no issue with having them as constants in a measure. If anything i would move the "0.8" into a different measure in case that you need to use the target value in other calculations.
Target % = 0.8 TargetValue = [NumOrders]*[Target %]
Community ChampionIt very much depends on how you work generally. If the KPI targets are prone to change often it might be reasonable to have these values in an external source. If you implement the KPI values into the pbix-file it will mean that any changes to them will also have to be done in the Pbix and this might not always be a good solution.
What are your current concerns regarding the matter?
- Ritaf
Hi ,
Thank you for your repli
The goals are preety stable .
I just not sure , that my way is a good enough because it's my firt skpi's project.
I think it's can be simple mesure like:
Target = [NumOrders]*0.8 (for goal)
And
NumTypedOrders = calculate (distinctcount([NumOrders), filter(TimeOrdering = "0-1 days))/[NumOrders] (for excecution)
- tex628
If the amount of KPI-target values are few there is no issue with having them as constants in a measure. If anything i would move the "0.8" into a different measure in case that you need to use the target value in other calculations.
Target % = 0.8 TargetValue = [NumOrders]*[Target %]- Ritaf
Thanks a lot . I will go by this way 🙂
