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,
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 |
Hi,
See if my solution here helps - Filter a column of a Pivot Table on a certain condition but also show other items from that column.