How to count records with two numeric conditions

[#1]

I need to count the records that have values between 0 and  7,  I`m using the included expression, but with this one it count also records in negative

count(DISTINCT {<dayss ={'<=7'}>}[CONTRATOi])

[#2]

I found the solutions..

count({ $<dayss={'>0<=7'}>} distinct CONTRATOi)

[sunny_talwar · Accepted solution]

Try this:

Count(DISTINCT {<dayss ={'>=0<=7'}>}[CONTRATOi])

[buzzy996]

the other way,

count(DISTINCT {<dayss ={'0','1','2','3','4','5','6','7'}>}[CONTRATOi])

[ramoncova06]

you can close your thread