DAX: Why does COUNTROWS with a FILTER defining the table return an error?
17:26 02 Feb 2022

I am trying to perform a COUNTROWS on a filtered table where column 'galaxies'[name] = "Milky Way"

Here is my dax measure:

test_measure = 
  COUNTROWS(
    FILTER(
      'galaxies',
      'galaxies'[name] = "Milky Way"
      )
  )

When I run this, I receive an error saying "The expression specified in the query is not a valid table expression".

Why is this an error? FILTER returns a table and COUNTROWS takes a table as its argument.

powerbi dax ssas business-intelligence ssas-tabular