Distribute value proportionally

[lakshmittpd]

Hi, I have a requirement in which I need to distribute a calculated measure proportionately to another measure which is aggregated by dimension. Please find the below example.

Dim.        Mes1.        Mes2

A                20               20+(20*50)/100  = 30

B                30               30+(30*50)/100=45

C.               50               50+(50*50)/100=75

D.                0                 0+(0*50)/100 = 0

calculated 3rd measure is 50

pls let me know the expression for measure 2

[sunny_talwar]

Where is this 3rd measure coming from?

[lakshmittpd]

dim.        Mes1     Mes2  dim

                  20                       Support

                  30                        Support

mes3=20+30 where dim is null

[sunny_talwar]

I am not sure I am able to follow... would you be able to share a sample qvf where we can see the data?

[lakshmittpd]

Hi,

I attached excel sheet with data. For each dimension1 measure1 will be recorded. measure 2 calculation is available in excel. Measure 1 and measure 2 sum gives the measure 3.

Support multiple projects value is obtained when dimension 1='ABC' 

Please let me know if this explains.