Need to multiply two measures and find the sum of the column.

[Anonymous]

Hi Team,

I have a bit wierd requirement.

I have a table visual wherein I have all measures except one column which is the first one in the table below (PF).

PF	act	play	diff	abs diff	err	err%	acc weight
A	30	30	0	0	0	0.00%	0.027
B	30	62	-32	32	1.0667	106.70%	0.027
C	58	85	-27	27	0.4655	46.60%	0.052
D	6	6	0	0	0	0.00%	0.005
E						0.00%	0
F	14	29	-15	15	1.0714	107.10%	0.013

Rest others are derived measures. 
My page has two slicers, one to select the play type on which the values under the play column changes and so the others after it and the other slicer is for showing MTD,QTD and YTD.

What is required is I need to multiply err and acc weight row by row and then SUM the entire column values.
For example:
0 * 0.027 = 0
1.0667 * 0.027 = 0.0288009 and so on and then SUM(0+0.0288009) = 0.0288009 as the final value. 
It is like the SUMPRODUCT function in excel but the problem here is all the fields are measures.
Is this achievable? 

Any help  would be highly appreciated.

Thanks,

Ani91

[v-yuezhe-msft]

@Anonymous,

Please check if the methods below return your expected result.

Method1:

Measure = [err]*[acc weight]

SumMeasure = SUMX(YourTable, [Measure])

Mehod2:

Measure = [err]*[acc weight]

SumMeasure = IF(COUNTROWS(VALUES(yourtablel[PF]))=1, [Measure],SUMX(VALUES(yourtablel[PF]),[Measure]))

Regards,
Lydia

[Anonymous]

Thanks Lydia. The second method was helpful. 

[Greg_Deckler · Accepted solution]

Sure, there are common techniques for this using things like SUMX. Take a look at my Quick Measure, Measure Totals, The Final Word as it uses a technique that should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[Anonymous]

Thanks a lot Greg_Deckler. It worked like a wonder and eased all my further calculations. Thanks a lot again for the wonderful article.