Forum Discussion
Anonymous
10 years agoNot applicable
Cannot get KPI working because of count
I try to create a KPI for this situation. We have consultants booking their hours. I have these hours (in minutes) in Power BI. Another "table" is the name of the consultant and the minutes they a...
KGrice
Memorable Member
10 years agoIt sounds like you have the KPI of 360 repeated for every row in your table, 1 row for each of your 30 consultants. If it defaults to a count when you drag it into your report, it's probably set as text rather than a number, which would default to a sum. You could create a measure to handle this as
Target = MAX(TableName[KPI Column Name])
Even if each consultant has a different target, this will show their KPI (if your data is like I'm picturing it).
I also sometimes create my KPIs as a separate measure anyway, especially if it's going to be static. You can create a measure like:
Target = 360
That will show 360 no matter where or how you use it in your report, as it's separate from your table.