Forum Discussion
Solved
Count Measure not showing zero
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...
Solved it - I put >=0 and that brought it all in. Thanks
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?
Thanks, that populates the zero but everything else disappears