topic Re: Using 'product' function by group in DAX Commands and Tips

Using 'product' function by group

Anonymous — Fri, 22 Jul 2022 14:49:07 GMT

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.

Re: Using 'product' function by group

tamerj1 — Fri, 22 Jul 2022 15:21:18 GMT

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?

Re: Using 'product' function by group

LFS — Fri, 22 Jul 2022 15:29:21 GMT

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.

Re: Using 'product' function by group

tamerj1 — Fri, 22 Jul 2022 15:37:05 GMT

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] )

Re: Using 'product' function by group

LFS — Fri, 22 Jul 2022 17:40:45 GMT