Counting Not working inside slice

Hi there,

i have something really weird happening, i have tried to figure out the reason but with no luck.

i have a slice which filter rows according to this condition:

and(in([SKU Item],select(Create PickList[SKU Item],true)),
in([id],top(select(BIN Products[ID],[SKU Item]=[_thisrow].[SKU Item]),[_thisrow].[to be picked quantity])))

this slice is taken from the table BIN Products and it called Picklist.

the condition is working fine and i can see the results that i want.
the issue is i want to count the number of rows inside the slice and it should be simple like :
count(Picklist[_rownumber])
but the results is always zero. i can count records for any other slice only this slice that always give zero

any ideas ?

0 1 174
1 REPLY 1

Steve
Platinum 4
Platinum 4

Where is the COUNT() expression being used? Please post a screenshot.

Top Labels in this Space