Forum Discussion
comparing negative values in DAX
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.
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")
4 Replies
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")
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
I have a calumn with ticket response time (TTR) If the value is negative then the KPI is not met.
