Forum Discussion
Anonymous
4 years agoNot applicable
Creating a column count by different values from another column
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
Hi Anonymous
You may try
COUNTROWS ( CALCULATETABLE ( Table, ALLEXCEPT ( Table, Table[Column1] ) ) )
2 Replies
- tamerj1Community Champion
Hi Anonymous
You may try
COUNTROWS ( CALCULATETABLE ( Table, ALLEXCEPT ( Table, Table[Column1] ) ) )
- AnonymousNot applicable
Such a genius, it works, thanks a million!