cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

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)
)
 
2 REPLIES 2
Super User IV
Super User IV

@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.

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors