COUNT Weeks with Value between Levels

joshua1990 — Mon, 06 Jun 2022 14:36:49 GMT

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?

Re: COUNT Weeks with Value between Levels

tamerj1 — Mon, 06 Jun 2022 20:23:34 GMT

Please try

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