Forum Discussion

Ritaf's avatar
Ritaf
Icon for Responsive Resident rankResponsive Resident
6 years ago
Solved

Kpis modeling - general question

Hi all, I am creating my first kpi's dashboard. I have some doubts  whith what is the best practice to create it. Specialy my question is about goals and targets. For Example my first  KPI relate...
General Comment
Interesting Links
Need Help
Tips and Tricks
  • tex628's avatar
    tex628
    6 years ago

    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 %]

     

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
6 years ago

It 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?