How to create a measure using a range

[kg4u]

Hey PBI Group,

I have an easy one for you today, I'm still a rookie and trying to learn...

In my Data table, I have a column called Days Open.  What I would like to do is create several measures based on the values in the Days Open column.  

For example:

<30 Open = CALCULATE(COUNTROWS('Data Table'),'Data Table'[Days Open] > 0, <=30)

but the syntax isn't correct, and I am not able to find any examples of how to use a Range to create the measure.  Any suggestions?

Thank you!

[Syk · Accepted solution]

Just a small tweak should work. You need to write the 'Data Table'[Days Open] again and specify to use AND (&&) or OR(||).

<30 Open = CALCULATE(COUNTROWS('Data Table'),'Data Table'[Days Open] > 0 && 'Data Table'[Days Open] <=30)

[kg4u]

Awesome thanks Syk!