Forum Discussion

Oros's avatar
Oros
Post Prodigy
2 years ago
Solved

COUNT rows with filter

Hello,   How do you create a measure to COUNT many rows have zeros (in the VARIANCE column),  but excluding the zero IF  INVENTORY=0 and COUNTED=0   In the example below, the measure should o...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Assuming Inventory, Counted and Variance are measures that you have written, write this measure

    Measure = countrows(filter(Values(Data[Product]),[Inventory]<>0&&[Counted]<>0&&[Valiance]=0))

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Assuming Inventory, Counted and Variance are measures that you have written, write this measure

Measure = countrows(filter(Values(Data[Product]),[Inventory]<>0&&[Counted]<>0&&[Valiance]=0))

Hope this helps.

  • Oros's avatar
    Oros
    Post Prodigy
    2 years ago

    Hi Ashish_Mathur ,

     

    Thanks you for your quick reply.

     

    The Inventory, Counted and Variance are all measures.  I noticed that your measure does not count the zeros correctly.  Is it because the Inventory and the Counted have blank values?

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      You are welcome.  If they have blanks, then why did you mention/show 0 in your original post.  Try this revised measure

      Measure = countrows(filter(Values(Data[Product]),[Inventory]<>blank()&&[Counted]<>blank()&&[Variance]=0))

  • Oros's avatar
    Oros
    Post Prodigy
    2 years ago

    Hi Ashish_Mathur ,

     

    This works!  Thanks a lot!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      You are welcome.