Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count Rows per Group with Filter Responsiveness

Hi folks, I'm trying to create a measure that will respond to filters to give me the number of rows in each group (defined by the value of two columns). Example: ID Classification Days Count ...
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    try a measure

    Count = CALCULATE(COUNTROWS(TableName),
FILTER(ALLSELECTED(TableName),
TableName[Classification]=SELECTEDVALUE(TableName[Classification]) && TableName[Days]=SELECTEDVALUE(TableName[Days])))
VasTg's avatar
VasTg
Memorable Member
6 years ago

Anonymous 

 

Replace COUNT with DISTINCTCOUNT

 

If it helps, mark it as a solution
Kudos are nice too