Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count rows ignoring value in other rows

Hi all,   I need to create a measure from a single table "Pols Outcome", that provides me with what I believe is a countif, but I can't quite figure it out by videos. I need a single measure that g...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Try this measure

    =CALCULATE(COUNTROWS('Pols Outcome'),'Pols Outcome'[Canx/Void]<>"Void"&&'Pols Outcome'[AP]>0)

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Try this measure

=CALCULATE(COUNTROWS('Pols Outcome'),'Pols Outcome'[Canx/Void]<>"Void"&&'Pols Outcome'[AP]>0)

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    No luck unfortunately! 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 years ago

      Hi,

      Replace the && with a ,

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Ashish_Mathur  The below worked perfectly! Thank you for the response over the weekend and quick reply this morning!
     
    AP Cases = CALCULATE(COUNTROWS('Pols Outcome'),'Pols Outcome'[Canx/Void]<>"Void",'Pols Outcome'[AP]>0)
     
    Kind regards,
     
    Jordan 
     
     
    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 years ago

      You are welcome.