Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Check ID in another table

Hi,   I have two tables related with each other with an ID number (many to one). From the one side I want to check in the column of the many table if the ID exists in this table (specific column). ...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

Based on your description, I created data to reproduce your scenario.

OneSideTable:

ManySideTable:

 

Relationship:

 

Then You may create a measure as follows.

 

Ispacked = 
IF(
    COUNTROWS(
        RELATEDTABLE(ManySideTable)
    )>0,
    "packed",
    "unpacked"
)

 

 

Finally you may use a table visual to display the result.

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    Thanks for you help. However I get no detailed view of packed lines. ID's are empty (on both formulas you suggested). Data link is based on direct query.