Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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...
Show and Tell
jahida's avatar
jahida
Icon for Impactful Individual rankImpactful Individual
10 years ago

I'm guessing what you want instead is Sum. If that's the case, make sure your column (I'm guessing it's a column) is formatted as a number (not text). Then, on your KPI visual, hit the little down arrow beside the Target field and click on Sum.

 

An alternate solution would be to define a measure that does the summarization for you and use that in your KPI (could be something as simple as Measure = SUM(Table1[Target]).

 

If neither of those work, maybe post a screenshot or two of what you're seeing.

 

Hope that helps!