comparing negative values in DAX

[cizaguirredigi]

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. 

[PaulDBrown · Accepted 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")

[cizaguirredigi]

@PaulDBrown it worked perfectly as a Measure!!! Thank you very much for the support!!!!

[ryan_mayu]

@cizaguirredigi 

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

[cizaguirredigi]

I have a calumn with ticket response time (TTR) If the value is negative then the KPI is not met.