Creating a column count by different values from another column

[Anonymous]

I have a column, that has some parameters, and I need to calculate how much rows has each parameter. In measure we use this formula:

Rowcounts = CALCULATE(COUNT(Table1[Column1]),FILTER(Table1,Table1[Column1]="Compliant"))

 but I don't need a mearure. I need a column that will contain each number of rows such rows per each row.
Btw, I have a lot of parameters, that why I can't filter them like this:

Table1[Column1]="Compliant"

 I need smth different, just filter by each automatically

[tamerj1 · Accepted solution]

Hi @Anonymous 

You may try

COUNTROWS ( CALCULATETABLE ( Table, ALLEXCEPT ( Table, Table[Column1] ) ) )

[Anonymous]

Such a genius, it works, thanks a million!