Display unique record

[pala_jagadeesh]

Hi, I have a table in datamodel like below

Rec No	product	Flag
1	AB	0
1	AA	0
2	BB	0
2	BC	0
3	CV	0
3	CD	0
3	CF	0
4	GH	0
4	GT	0
4	GY	0
1	AC	1
2	BD	1
3	CN	1

i want output like below , because rec_no 4 should not share with both flag values , it has value 0 only

Remaining all records share flag values 1 and 0 both

Rec_ No	Product
4	GH;GT;GY

How to write chart expession in front end to get above output

[pala_jagadeesh]

is there any possible to find count in KPI measure,

here count is  3

[pala_jagadeesh]

@MarcoWedel 

is there possibility to find the count of product in KPI as 3