Forum Discussion

glennm's avatar
glennm
Regular Visitor
8 years ago
Solved

Lookupvalue with multiple values

Hi all,   I have question regarding the lookupvalue function. Currently I have 2 tables: - 1 table with all the IDs and their corresponding location (but 1 ID can be mapped to multiple locations) ...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi glennm,

     

    You could create a summarize table as below:

    Result Table =
SUMMARIZE (
    'ID-Location',
    'ID-Location'[Location],
    "Total Request", COUNT ( 'ID-Location'[ID] )
)

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi glennm,

 

You could create a summarize table as below:

Result Table =
SUMMARIZE (
    'ID-Location',
    'ID-Location'[Location],
    "Total Request", COUNT ( 'ID-Location'[ID] )
)

 

Best regards,

Yuliana Gu