Convert Dual COUNTIFS to CALCULATE /COUNTROWS

[pete234]

=CALCULATE(COUNTROWS('M2'), ALLEXCEPT('M2', 'M2'[AEE]))

This works if I want to count the rows from the type of sales rep AEE.
However, the original formula references another field next to it to group the calc by 2 reps instead of one.

How can I modify this formula to also include a name field next to AEE.
In other words, count lines grouped by REP 2 grouped under REP 1.

 

[Laurent C]

Showing us a sample of your data and the expected result would help a lot.

 

[pete234]

Well now it seems to be working correctly, I just used it again in another table.
It's just 2 columns of names both with repeating values.
Trying to get unique counts of 2nd value under the first (as if concatenated) but I guess row count is seeing the first name as a type of hierachy.
So it is working.