Create a slice of what left

Itay_Golan
Participant III

Hi,
This app is for scan barcodes and updates data for gas reading.
I have a “database” table that includes all the names referenced to the barcodes.
the other table is “Reading”, which records all the gas reading

I’m trying to create a slice that includes all the barcode that left to do (from the database table)
let say I got 50 readings from 55 (55 are the total), that means I got 5 barcodes left, now I want a slice
of it.

I had tried:

in([barcode],db[Barcode]-select(reading[barcode],[_THISROW].[ID1]=[ID1]))

I hope I have made myself clear…

thanks in advance

0 2 140
2 REPLIES 2

Steve
Participant V

This?

NOT(IN([barcode], SELECT(reading[barcode], ([_THISROW].[ID1] = [ID1]))))

It seems right. but it shows me all the barcodes.
in addition, the slice should be a tab on a dashboard…

Top Labels in this Space