Forum Discussion

apagan's avatar
apagan
Helper I
9 years ago
Solved

Count rows in a Table that have a specific value

I am using the formula below in an attempt to count the number of rows in a table that contain a value of "Pass" in a specific column, but this appears to be giving me a count of all the rows in the ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    apagan

     

    try with this:

     

    Pass= COUNTROWS(filter(Samples,Samples[AnalysisResult]="Pass"))

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

apagan

 

try with this:

 

Pass= COUNTROWS(filter(Samples,Samples[AnalysisResult]="Pass"))

  • apagan's avatar
    apagan
    Helper I
    9 years ago

    Outstanding!  Thank you!