Activity measure in Dynamic Cube

[andigrill]

Hello,

I have to implement a average measure with a activity measure (regular weight) in Dynamic cube: Avg of Column1 with activity measure Column2
In Transformer I created a non visible measure for column2, set set the measure to Column1 with this non visible measure as regular weight.

Col1   Col2
23        1
14        0
15        1

Avg measure should result in 19 (in Transformer).
How do I implement this in Cube Designer? I have defined 2 measures one for Column1 and one for Column2. Then I created a calculated measure with measure1*measure2. Unfortunately, The two measures are summarized before the calculated measure is calculated. Therefore I get sum(Col1)*sum(Col2) = 67.

I think I have to implement this somehow with dimensional functions, but where do I find a guidance?

Thanks