Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 it, but all end up in the same way. Counting all rows, instead of the ones filtered.
Here is one of the measures I use in a column:
Solved! Go to Solution.
@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]))
Thanks @amitchandak. It did not work, unfortunately. It outputed the same value in all rows as well.
I'm adding a print screen of an excel with my wanted output, hope it explains.
@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]))
User | Count |
---|---|
134 | |
68 | |
68 | |
54 | |
52 |
User | Count |
---|---|
207 | |
95 | |
64 | |
61 | |
57 |