Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm trying to calculate KPI's in PowerBi. For example we have tickets associated with a Time to resolved being 29m (Actual data) and some other tickets that have a value of -2h 30m. I'm trying to find a formula which can help me determine that if it's a positive value then it meets the kpi, otherwise if it's a negative value then it does not meet.
Solved! Go to Solution.
Try:
1) As a calculated column:
meets kpi = IF(CONTAINSSTRING(Table[TTR H:M], "-"), "Not meet", "Meet")
2) As a measure:
meets kpi = IF(CONTAINSSTRING(MAX(Table[TTR H:M]), "-"), "Not meet", "Meet")
Proud to be a Super User!
Paul on Linkedin.
Try:
1) As a calculated column:
meets kpi = IF(CONTAINSSTRING(Table[TTR H:M], "-"), "Not meet", "Meet")
2) As a measure:
meets kpi = IF(CONTAINSSTRING(MAX(Table[TTR H:M]), "-"), "Not meet", "Meet")
Proud to be a Super User!
Paul on Linkedin.
@PaulDBrown it worked perfectly as a Measure!!! Thank you very much for the support!!!!
not sure if 'IF' function can meet your request.
IF(value>=0, "meet","not meet")
it's better to provide some sample data and expected output
Proud to be a Super User!
I have a calumn with ticket response time (TTR) If the value is negative then the KPI is not met.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |