KPI Indicator

[Kenneth]

Hi all,

I am trying to figure out how to use the KPI Indicator.  My aim is to be able to show the total number of customer complaints in a KPI indicator. I would like to filter on month and year. My current solution works fine when filtering on month. But when filter on year  the KPI indicator returns 0.

Below is my current solution which doesn´t work as planned

1. Measure, as below! I would like to count rows inluding the text "Customer Complaint"

Measure = if(isblank(CALCULATE(COUNTROWS(Agility),Agility[Sub-Type1] ="Customer Complaint")),0,(CALCULATE(COUNTROWS(Agility),Agility[Sub-Type1] ="Customer Complaint")))

2. When filtering on year and month it works as below picture

3. But when I filter on only year I get as below. I would like the KPI to show 6 and target 10 according to the table

Thank you for your help,

Kind regards,

Kenneth

[Greg_Deckler]

Would need to see some sample data because I don't see anything obvious. Perhaps there is something wonky with your Year slicer and you are using a Year from a different table?

[Kenneth]

@Greg_Deckler Please find some tables below. My idea is to build up a dashboard and I need to be able to filter on Date ( year & month) and Terminal.

 

Thanks

K

[Kenneth · Accepted solution]

@Greg_Deckler

I found some information in below link. It doesn´t completely fulfill my needs, but good enough

http://community.powerbi.com/t5/Desktop/KPI-Visualization-with-Trend/td-p/132259