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

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

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.