Forum Discussion

cizaguirredigi's avatar
cizaguirredigi
Frequent Visitor
3 years ago
Solved

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 fin...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    3 years ago

    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")

ryan_mayu's avatar
ryan_mayu
Super User
3 years ago

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's avatar
cizaguirredigi
Frequent Visitor
3 years ago

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