Forum Discussion

FredWamaa's avatar
FredWamaa
Regular Visitor
6 years ago

KPI Measure

I am trying to create a measure to use in a KPI, the Target goal is 95% . The table has Alarm times which were flagged 1 if they were under 1 minute and 0 if they were over one minute.  The KPI will now compare all the rows using 95 % as the bench mark by year. I tried this , it gives a rate of all the columns

 
 
Goal = DIVIDE(
CALCULATE( SUM( vwFD_Data[AlarmTime_1Min]),
FILTER( vwFD_Data, vwFD_Data[AlarmTime_1Min] = 1)
),
COUNTROWS(vwFD_Data)
)
 
Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    FredWamaa , the formula seems fine. case share error screenshot

     

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

    • FredWamaa's avatar
      FredWamaa
      Regular Visitor
      6 years ago
      AlarmTime_1 MinAlarm Rate (if time is less than 1 min then goal is met)Alarm Goal KPIKPI
      087%95%Target Not met
      198%95 %Target goal met
      197%95%Target goal met
      092%95%Target goal not met
      198%95%Target goal met
      090%95%Target goal not met

       

      The previous DAX created a column flagged as 1  or 0, depending if the time was met. Times flagged as less than 1, meaning goal not met.  Am trying to create different column just showing the Alarm goal and use it to calculate a KPI . Thank you