Hi
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.
thanks
Phil
Create VC like
If
IF(
COUNT(SELECT(Orders[Order Id],AND([_THISROW].[Outlet No]=[Outlet No],[Order Status]=“Open”)))>0,
true,
false
)
And use this VC to slice it out?
Try something like:
ISNOTBLANK(
FILTER(
"Orders",
AND(
("Open" = [Order Status]),
([_THISROW].[Customer Id] = [Customer Id])
)
)
)
User | Count |
---|---|
41 | |
27 | |
27 | |
20 | |
13 |