Target value to a column in table

[chalapathy]

I have a parameter setup for user to input target production. I have a table that have percent allocation and associated price.

Something similar to the following. Based on target, I would like to display Weighted average Price in a Card.

Tried Using measures for multiplying. While the Qty and Ext display properly, the Wgt. Avg is not returning proper value.

Can an

Target:	3200	Parameter Input
TABLE	Calculated Columns
Item	% Alloc	Unit P	Qty (Target*% alloc)	Ext. (Qty*Unit P)
A	25%	22	800	17,600
B	0%	40	-	-
C	40%	30	1,280	38,400
D	15%	0	480	-
E	20%	45	640	28,800
			3,200	84,800
		Wgt. Avg P	26.5

[Anonymous · Accepted solution]

Hi  @chalapathy ,

Here are the steps you can follow：

1. Create measure.

Wgt. Avg P =
DIVIDE(
    SUMX(ALL('Table'),[Qty] * [Unit P])
    ,
    SUMX(ALL('Table'),'Table'[%Alloc])* 3200)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[chalapathy]

Thank  you. Sorry for the late reply. It was long weekend and holidaying.