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"))

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago
Measure = CALCULATE(COUNTAX(Samples,Samples[AnalysisResults]),Samples[AnalysisResults]="Pass")