KPI creation

Hi Anonymous 

I build a sample with 2281 employees that number from 1 to 2281. In my sample 1825 employees have answered.

Firstly, we need to build two measures.

Answer Rate = 
VAR _CountAnswer = CALCULATE(COUNT('KPI'[Date]),ALL('KPI'))
VAR _CountAll = CALCULATE(COUNT('KPI'[Employee Number]),ALL('KPI'))
VAR _RATE = DIVIDE(_CountAnswer,_CountAll)
Return
_RATE

Target = 0.75

We need to change two measures' format as Percentage in Measure tools.

Gauge visual:

Kpi visual:

For more details about how to build a KPI or Gauge visual, you may refer to the blogs: KPI and Gauge

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.