Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
FredWamaa
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
amitchandak
Super User
Super User

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

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.