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.

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.