Forum Discussion
Solved
Target value to a column in table
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 d...
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
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
Thank you. Sorry for the late reply. It was long weekend and holidaying.
