COUNT Weeks with Value between Levels

[joshua1990]

Hi experts!

I have a simple DIVIDE Measure (Measure x) that shows me the Ration between two different measures:

DIVIDE ([Measure 1], [Measure 2]).

Now I would like to get the number of weeks where Measure X has values below 0.075 (7,5%).

I tried this using the logic:

CALCULATE (
    COUNTROWS ( VALUES ( 'Calendar'[Week] ) ),
    FILTER ( 'Calendar', [Measure X] >= 0 && [Measure X] < 0.075 )
) + 0

Unfortuntely this is not working. I always get 23 > Number of weeks this year so far.

Do I need COUNTX here?

[tamerj1 · Accepted solution]

@joshua1990 

Please try

Number of Weeks < 0.075 =
COUNTROWS (
    FILTER ( VALUES ( 'Calendar'[Week] ), [Measure X] >= 0 && [Measure X] < 0.075 )
)