Using measure value for other dimension's values

[bdb]

Hello,

I have a simple table (or chart) to calculate Emissions, which is Electricity * Emission factor.

The measure Emission Factor is only populated for the calendar dimension in each year's January (1/1/YYYY), while the Electricity measure is populated over the same calendar dimension but for each month (1/MM/YYYY).

Is there a way to use Emission Factor's January value in the other calendar dimension's months?

I'm trying to setup a master dimension to reuse in multiple charts.

I've tried ABOVE (doesn't really work for master dimension), set analysis (selecting the month, but it always respects the chart's calendar dimension), TOTAL (needs to "respect" the calendar dimension, and location), with no avail.

This works perfectly if I have a yearly calendar dimension: it sums up all values of the year, and multiplies correctly.

I'd appreciate any insight,

[Or]

This would not be possible, since the measure is only calculated once the dimensions are known.

You could work around this by using AGGR() to some extent, depending on the specific requirements.