Forum Discussion
Lookup or Search Multi-Select Between Tables
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.
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.
Hi sturlaws - This is great thank you! How would I add the workstream level search into that same calculation so it does a contains for exact project level IDs first and then exact workstream?
Depends on how you want to handle lines with missing workstream id
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.
have a look at the attached pbix-file below, I replaced null with Workflow ID is missing to improve usability