Forum Discussion
Solved
COUNT Weeks with Value between Levels
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?
Please try
Number of Weeks < 0.075 = COUNTROWS ( FILTER ( VALUES ( 'Calendar'[Week] ), [Measure X] >= 0 && [Measure X] < 0.075 ) )
1 Reply
Please try
Number of Weeks < 0.075 = COUNTROWS ( FILTER ( VALUES ( 'Calendar'[Week] ), [Measure X] >= 0 && [Measure X] < 0.075 ) )