Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |