Forum Discussion

newby-001's avatar
newby-001
Regular Visitor
5 years ago
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:    

LevelTotal
024
12
2 
36
4160

However when I do a count:

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

I get the following:

LevelTotal
0 
12
2 
36
4160

Any ideas how I can populate the the level 0?

 

Thanks

 

 

Need Help

4 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    5 years ago

    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's avatar
      newby-001
      Regular Visitor
      5 years ago

      Thanks, that populates the zero but everything else disappears

  • newby-001's avatar
    newby-001
    Regular Visitor
    5 years ago

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

    • v-yalanwu-msft's avatar
      v-yalanwu-msft
      Community Support
      5 years ago

      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.