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...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 

    You may try

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

     

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 

You may try

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Such a genius, it works, thanks a million!