Forum Discussion
Seems like a LOOKUPVALUE problem?
Hi experts, I have a table 'poc_memberrecords' I want to pick all the 'poc_memberrecordid' containing 'Cosmetics' in 'poc_departmentname'. (but not only containing 'Cosmetics' as the same 'poc_memb...
Hi Anonymous
Create a measure
Measure = IF(NOT(ISERROR(FIND("Cosmetic",MAX([poc_departmentname])))),1,0)Create a new table
Table = VAR filtered1 = FILTER ( SUMMARIZE ( poc_memberrecords, poc_memberrecords[poc_memberrecordid] ), [Measure] = 1 ) RETURN FILTER ( poc_memberrecords, [poc_memberrecordid] IN filtered1 )Best Regards
Maggie
Hi,
The entries in the poc_departmentname of the first table are not in English. The entries in the poc_memberrecordid column are absolutely different. Neither do i understnad yoru question nor the expected result.
Hi,
I've revised it and it should be easier to understand now.
Hi,
I still do not understand. In the first table there is supermarket appearing against 12345. Why in the second table is there 12345 appearing 3 times with Cosmetics, Clothes and Restaurant. I just do not understand.
The second table:
poc_memberrecordid poc_departmentname 12349 Cosmetic 12348 Cosmetic 12348 Cloth