Forum Discussion

daxn00b's avatar
daxn00b
Frequent Visitor
5 years ago
Solved

Get data rows rather than count of rows?

Anyone know how to get the data rows rather than count of rows with the example below?   Green Cars =
 VAR color_green =
 SUMMARIZE ( FILTER ( ALL ( Data ), Data[color] = "green" ), Data[computer...
  • daxer-almighty's avatar
    daxer-almighty
    5 years ago

    A DAX measure CANNOT return a table. It can only return a scalar value. You can create a table via DAX but it will not be returned by a measure. It can only be created as a table in the model and will be STATIC once created.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

 

You can create another table :

Green Cars =

VAR color_green =

SUMMARIZE ( FILTER ( ALL ( Sheet1 ), Sheet1[Country] = "Canada" ), Sheet1[Index] )

VAR type_car =

SUMMARIZE ( FILTER ( ALL ( Sheet1 ), Sheet1[Country] = "France" ), Sheet1[Index] )
RETURN

UNION(color_green,type_car)