Use disconnected measure values in another measure

[facilitydax]

Hi - I have a table that is disconnected from all the other data that just holds year values. I use this table of years in measures in the regular data structure to generate time based measure outputs (statistical weibull formulas). It works out nice because I can graph the measure over time. 

I'm also calculating some separate "factors" (measures) which change based on the year and budgets from another disconnected table. The problem is that I can see these values if I put them in a table as seen below in the red box - however, I cannot use them in another measure in the regular dataset. If I call the FactorA and FactorB in another measure, it does not use the 83.09 and 1.02 as seen below.  Therefore, as a janky temporary solution, I have to transfer these in two parameter boxes and then use those values in my new measures.

Any ideas on DAX statements to let me call these Factor measures and be able to use them in another measure?

Unfortunately, I cannot share the file since it's sensitive information.  Thanks in advance.

[v-frfei-msft · Accepted solution]

Hi @facilitydax ,

To call the measure in another new measure, we should make it ignore filter. So all function is necessary here. We can create measures as below.

Measere B = CALCULATE(SUM(FB[Factor B]),ALL(FB))

Measure A = CALCULATE(SUM(FA[Factor A]),ALL(FA))

call measure = CALCULATE(SUM(category[value])) +[Measere B] +[Measure A]

Then we can get the excepted result as below: