Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

  • tamerj1's avatar
    tamerj1
    Community Champion

    Hi Anonymous 

    You may try

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Such a genius, it works, thanks a million!