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.