I have a standard parent child order system.
I have a slice of an orders table that gives the customers with open orders below
COUNT(SELECT(Orders[Order Id],AND([_THISROW].[Outlet No]=[Outlet No],[Order Status]=“Open”)))>0
I’m trying to find the yes/no expression for a slice of the customers table to show the customers with an open order rather than a slice of the orders table.