Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
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.
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.
Hi,
You can create another table :
@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 )
User | Count |
---|---|
47 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |