Forum Discussion

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_id] ) 

VAR type_car = 

SUMMARIZE ( FILTER ( ALL ( Data ), Data[type] = "car" ), Data[computer_id] ) 

RETURN 

COUNTROWS ( INTERSECT ( color_green, type_car ) )

Thanks!

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.

amitchandak
Super User
5 years ago
daxn00b , Create a table like below

Green Cars = 

VAR color_green = 

SUMMARIZE ( FILTER ( ALL ( Data ), Data[color] = "green" ), Data[computer_id] ) 

VAR type_car = 

SUMMARIZE ( FILTER ( ALL ( Data ), Data[type] = "car" ), Data[computer_id] ) 

RETURN 

INTERSECT ( color_green, type_car )
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)
daxer-almighty
Solution Sage
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.