Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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