Using 'product' function by group

[Anonymous]

Hi, 

With original Table 1, 

First, I would like to multiply Rate% by the same WO no. From Table 1; I am not sure which fomular I should use such that only multiply for the same group in WO column.

Then, I would like to average Yield % in Table 2 by the same WO no. 

Please advise fomular I should use.

[tamerj1 · Accepted solution]

@Anonymous 

Not sure if I correctly understand, but please try 

Yield % =
VAR T1 =
    SUMMARIZE (
        TableName,
        TableName[WO],
        TableName[Product],
        "@Yield", PRODUCT ( TableName[Rate] )
    )
RETURN
    AVERAGEX ( T1, [@Yield] )

[LFS]

Good morning everyone.
Has anyone ever made an application in Visual Studio (Vb.net) to open a Gravico or destbord in the form of an application. And would you have some example to send me Or could you describe how it was done.

[LFS]

Good morning everyone.
Has anyone ever made an application in Visual Studio (Vb.net) to open a Gravico or destbord in the form of an application. And would you have some example to send me Or could you describe how it was done.

[tamerj1]

Hi @Anonymous 

do you have relationships between the two tables? Can you clarify? I assume you want (1.0 x 1.0 ) x (1.0 + 1.0)/2 is that correct?