Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
@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.
AlarmTime_1 Min | Alarm Rate (if time is less than 1 min then goal is met) | Alarm Goal KPI | KPI |
0 | 87% | 95% | Target Not met |
1 | 98% | 95 % | Target goal met |
1 | 97% | 95% | Target goal met |
0 | 92% | 95% | Target goal not met |
1 | 98% | 95% | Target goal met |
0 | 90% | 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
76 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |