Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |