I have been playing out with how to figure out how to do a contains filter for two tables that I am unable to join due to the lack of data for some of the values.
In on table I have:
|Project ID||Workstream ID||Value|
In a master table I have in the dataverse, I have:
|Project ID||Workstream ID|
Since some of the data entered don't have Project IDs, I would like to filter the data from the Project Level to show all underlying workstreams (including blank IDs). If there is a Workstream ID, when I select the second level of the hierarchy from the master table, I would like to only see that Workstream ID.
Normally I would use a key to join the two tables but the items with blank Workstream IDs would not be brought in.
I tried the following measure but it obviously only works at the project level. Is there any way to have it use the Project ID / Workstream ID hierarchy from the master table to say that if the Workstream ID is blank then search the project and if I select a Workstream ID then locate the Workstream ID?
Measure 2 =
VAR searchvalue =
SELECTEDVALUE ( Master[ProjectID] ),
SELECTEDVALUE ( Data[ProjectID] ),
IF ( searchvalue > 0, "Found" )