Merge Data created in Measures

DataInsights - thanks for your help.......

Sorry for the delay, i had to create an example (my actual PBIX file in on a network that i cannot export from - sorry)

So my example file is HERE

I have also attached the EXCEL here - and the desired output is on the tab [RESULTS]

I need to create the result using the 2 x Measures i have created [ARM_1] and [ARM_2] as these replicate what i have in the other model.

Thanks for your help

sorry,

here is the PBIX file again - FILE

So if you look at the tab [ARM_2] you will see that i have the tags [Project] and [DD]..... however, each [Project] tag does not have both [DD] tags - the L and the M (AA does; BB does not have the M etc)

What i am after is on the tab [Results] is to have for each [Project] the L and M tags

Where there is not a value from [Table 2], it takes the value from the corresponding [Project] in [Table 1]

So it looks like the results in the [Result] tab in Excel

Does that help??

yes, but as i say, please ignore the 2 tables............

i have to use the 2 x measures to create the answer......

If you can create a measure using the data in [Measure 1] and [Measure 2] that would be fantastic