Need help calculating Null and No null values in column

Hi parry2k 

Test with this data

First Create a calculated column

year/weeknum = YEAR(Table1[Date])&"-"&WEEKNUM(Table1[Date],2)

Then Create two measures

count not null = 
CALCULATE(COUNT(Table1[Date]),FILTER(ALLSELECTED(Table1),Table1[year/weeknum]=MAX(Table1[year/weeknum])&&Table1[Test Number]<>BLANK()))

count null = 
CALCULATE(COUNT(Table1[Date]),FILTER(ALLSELECTED(Table1),Table1[year/weeknum]=MAX(Table1[year/weeknum])&&Table1[Test Number]=BLANK()))

Add them to a line chart

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.