Create a measure with only one statment ( IF, TRUE)

[carebear88]

Hi guys!

I need help with something that seems so simple but I just can't figure it out. Please help me.

I have a row with columns that gives me values from 0 and up. I want to create a measure that only gives me the results that are 40 or higher. How can I create a simple DAX function that gives me the ability to only present the cases that have a value of 40 or higher?

Example of my columns and rows are:

Case type          Value(weight)

Incident              0

Incident              40

Near miss           380

Incident              2

Near miss           0

Thank you ❤️

[HotChilli]

Are you saying you want to return rows where value > 39?

In this case, it's not a measure you create but a table

New Table = FILTER(oldtable, oldtable[Value(weight)]  > 39)

[carebear88]

Hi!

I want to return rows that are 40 or higher. 

Ok so I should add a new table with the following ; New Table = FILTER( Casetype,casetype[Value(Weigth)] >39)) ?

Thank you!