DAX Group by then filter not working

[DevM01]

I want to group by an accountId field then I want to filter based on a specific column, I tried to do this: 

COUNTROWS(Filter( GROUPBY(entries, entries[accountId]), [my filter column] <> "some value") ) 

However, it's telling me that my filter column can't be found. Isn't this the right way to group by, then filter? Thanks 

[Anonymous · Accepted solution]

@DevM01 

The GROUPBY is similar to the SUMMARIZE, the problem is you must include the filter column in the table expression, otherwise you cannot find in the grouped table, should be like:

Measure = COUNTROWS(Filter( GROUPBY(entries, entries[accountId],[my filter column]), [my filter column] <> "some value") )

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@DevM01 , Try like

COUNTROWS(Summarize(Filter(entries, entries[accountId], [my filter column] <> "some value") ))