Count Measure not showing zero

[newby-001]

I have a list of data and trying to do a count measure.  The count works, except for anything for a "level" of 0.  The correct data is as follows when I put it in a table visual:    

Level	Total
0	24
1	2
2
3	6
4	160

However when I do a count:

= calculate(countrows(table1'),filter(table1',table1'[Level]&&table1'[s11]="e"))

I get the following:

Level	Total
0
1	2
2
3	6
4	160

Any ideas how I can populate the the level 0?

Thanks

[newby-001 · Accepted solution]

Solved it - I put >=0 and that brought it all in.  Thanks

[v-yalanwu-msft]

Hi, @newby-001 ;

Congratulations on solving the problem, Would you mind accept your replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

@newby-001 

Why you add table1'[Level] in the filter and didn't add any restrictions? 

maybe try this?

= calculate(countrows(table1'),filter(table1',table1'[Level]=0 || table1'[s11]="e"))

if still not work, could you pls provide some sample data?

[newby-001]

Thanks, that populates the zero but everything else disappears