IF Between two Values and BLANK

[joshua1990]

Hi experts!

I have a matrix that shows a relative measure for each week:

Week	Level
01	0.1%
02	2%
03	0%

The measure [Level] is a simple DIVIDE function. If the result of DIVIDE is BLANK, then a 0 will be dsplayed.

Level = VAR _Level =
    DIVIDE ( [Qty 1], [Qty 2], 0 )
RETURN
    IF ( ISBLANK ( _Level), 0, _Level)

Now I would like to count the number of weeks with a value between 0% and 2.5%.

For this I use the following measure:

Count = CALCULATE(COUNTROWS(VALUES('Calendar'[Week])), Filter('Calendar', [Level] >= 0 && [Level] < 0.025))

Somehow all weeks with an original BLANK value for LEVEL are not counted.

If Level results in a blank value that is changed by a 0 within the same function, then Count takes this not into consideration.

What can I also count here blank values?

[johnt75 · Accepted solution]

Count = COUNTROWS ( FILTER (
   ADDCOLUMNS( SUMMARIZE( 'Calendar', 'Calendar'[Week]), "@level", CALCULATE( [Level]) ),
   [@level] >= 0 && [@level] < 0.025
) )