Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 )
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
26 | |
17 | |
12 | |
12 | |
10 |
User | Count |
---|---|
33 | |
25 | |
16 | |
14 | |
13 |