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])))
az38's avatar
az38
Community Champion
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])))