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.

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , try like. add remove filter as per need. If you want to use OR use ||

countx(filter(table,table[Canx/Void]<>"void" && table[AP] <> 0),table[AP])
OR
calculate(countrows(filter(table,table[Canx/Void]<>"void" && table[AP] <> 0)))