Using results from a measure of a disconnected table

[facilitydax]

Hi - I have a simple year table that has 30 rows (2020 - 2050). This table is disconnected from my other table structure (let's call this DATASET 1) and I just use it as an input to some time based calculations.  For example, I have a measure that calculates the condition of an asset based on a degradation model.  Therefore, I can use that disconnected year as an x-axis and the measure from DATASET 1.  This all works great.

Now I have another table structure (let's called DATASET 2) which also uses that same Year table to run different calculations based on other parameters. Again, this works just fine.

What I'm trying to do now is use the output from a measure in DATASET 1 and use that as a variable in a measure within DATASET 2.  There's no direct join to create between these tables but they both use that common disconnected Year table. Specifically, from DATASET1 I have a ratio/factor being calculated by Year and I want to use that ratio/factor in another measure in DATASET2 that is calculated by Year.  

Thanks in advance!

[v-frfei-msft]

Hi @facilitydax ,

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[facilitydax]

@v-frfei-msft , thanks for the reply.  Unfortunately, this is a government related project with a massive data model. It would take way too much time to clean up a version to make it shareable. 

One other way to look at my problem, is that I basically need to do a "LOOKUPVALUES" function but I need to lookup the results of a measure in a disconnected table and I can't figure out how to achieve that.

Thanks again. 

[v-frfei-msft]

Hi @facilitydax ,

We can use the function ALL to ignore filter. Then we can get the value of the measure in another new measure.