Hi,
Is there a way to specify which measure to use with currentMeasure in a combination chart like in a crosstab?
here's an example: In the columns I have the mesasure for revenue and in the line I have a measure for 12 month moving average(a simple calculation using dynamic functions). When I use currentMeasure in the moving average measure it seems to use another measure than revenue, I can solve it by using "[revenue] within..." instead of currentMeasure, but I want a generic moving average which I can use in multiple visualizations instead of creating a new one all the time.
Another thing I've noticed is that sometimes when I try to drag the "moving average calculation" in to the line measure I get an error saying something like "It is only possible to insert a measure or a simple value into the selected location", this is the exact calculation that worked 10 minutes ago... Anyone have a solution or answer to that problem?
here's the calculation: average(currentMeasure/[Revenue] within set(lastPeriods(12;currentMember([Accounting].[Date].[Year]))))
Thanks CM