Measure, if column inferior var then in matrix

[Foguete]

Hello,

I am facing an issue with a new measure.

I want to use an if statement comparing a column to a var.

However, when I am using the measure in the matrix, it is not returning the good result.

Here is what I have so far:

CONECTIVIDAD? =
VAR conectividad = 6.75
VAR _horas = SELECTEDVALUE(TareasXOperariosXCias[Horas])
RETURN
IF(_horas<conectividad, "Revisar", "OK")

But here in my matrix, I only have "Revisar" even when "Horas" is higher than the VAR conectividad. For example the second line should show "OK"

Any idea how I could solve this issue ?

[Mahesh0016 · Accepted solution]

@Foguete 
# Create Measure by TareasXOperariosXCias[Horas] Then

Total Value = SUM(TableX[Value])

# Create 

CONECTIVIDAD? = IF([Total Value]<6.75, "Revisar", "OK")

@Foguete If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.