Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Countrows - Counting all rows of table, although filtered

Hi,  I'm trying to replicate the Excel function COUNTIF, to count how many times a manager's name appears in a table. I have read numerous guides on this, and tried a few different ways of solving...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , the Above formula, should work for what you shown in excel

    Team size = CALCULATE(COUNT(Table2[Manager]),FILTER(allselected(Table2),Table2[Manager]=max(Table2[Manager])))

     

    or

    Team size = CALCULATE(COUNT(Table2[Manager]),Allexcept(Table2,Table2[Manager]))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , the Above formula, should work for what you shown in excel

Team size = CALCULATE(COUNT(Table2[Manager]),FILTER(allselected(Table2),Table2[Manager]=max(Table2[Manager])))

 

or

Team size = CALCULATE(COUNT(Table2[Manager]),Allexcept(Table2,Table2[Manager]))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Many thanks amitchandak . Worked like a charm!