Return a value if a value is between to conditions

[Anonymous]

Hi Power BI Geeks,

Earnings achieved  = VAR X = [Hours of work] * 0.51

VAR Y = [Hours of work]

return

IF(Y>1248,X,0)

If I use this measure everything goes on the right way, except that it still includes the hours of work below 1248 whereas sums everything. If I apply this in the visual filter it returns only the selected values. 

Additionally how do you write a dax measure where i can show to values such as if Y > 1248 en Y < 1500.?

Thank you in advance.

[camargos88]

@Anonymous ,

Earnings achieved  = VAR X = [Hours of work] * 0.51

VAR Y = [Hours of work]

return

IF(Y>1248,X,BLANK())

[Anonymous]

Hello Camargos,

The measure you gave me does not work. Changing it into blank does only show blanks in each row but summed up it does not exclude the blank rows.