Forum Discussion

Longhorns2013's avatar
Longhorns2013
Regular Visitor
3 years ago
Solved

Lookup or Search Multi-Select Between Tables

Hi All,   I have been stuck on this for over a week now and could really use some help:   I have one data table that contains the following information:   Project ID Workstream ID Value ...
Need Help
  • sturlaws's avatar
    sturlaws
    3 years ago

    Hi, Longhorns2013,

     

    If you drop the relationship between your two tables, and write your measure like this:

    Measure =
VAR _master =
    CALCULATETABLE ( VALUES ( Master[Project ID] ) )
RETURN
    SUMX (
        CALCULATETABLE (
            Project,
            FILTER (
                Project,
                CONTAINS ( _master, Master[Project ID], Project[Project ID] )
            )
        ),
        Project[Value]
    )

     

     

    Cheers,
    Sturla

    If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

     

sturlaws's avatar
sturlaws
Resident Rockstar
3 years ago

Depends on how you want to handle lines with missing workstream id

Longhorns2013's avatar
Longhorns2013
Regular Visitor
3 years ago

sturlaws - if the Workstream ID is missing, it should just show the project ID associated to it. If it isnt then I would want the Workstream data.