Ref_rows for related order details

[Phil_Waite]

Hi,

I have an auto generated virtual column in a products table that refers to related order details.

The expression is this

REF_ROWS(“Order Details”, “Unique Product Id”).

I want to show the related order details in the order details table that it is refering to but only ones that have an [order status] =“Open”.

The SELECT expression below works to identify the “Order ID”

SELECT(Order Details[Order Id],AND(([Unique Product Id] = [_THISROW].[Unique Product Id]),([Order Status] =“Open”)

but it shows as

Related Order Details

7b58dd76 , c8624f15 , e6389889

Rather than show the inline rows that correspond to the order Id.

Thanks

Phil