How to create a measured column by disaggregating a value based on weights listed in a column

Question

Hi community,I am struggling with a rather theoretically easy task but not immediate on DAX that has kept me busy for a while.&nbsp;I need to create a measured column by disaggregating a value based on some weights that are listed in a column.&nbsp;So, as an example, the value I want to diasaggregate is 100 and the weights are listed in a column as:&nbsp;Weights0.30.40.60.30.4&nbsp;The result I am targeting in this example is:&nbsp;Weights&nbsp; &nbsp; Values0.3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150.4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200.6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300.3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150.4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp;Any idea?&nbsp;Thanks,Walter

jihwan_kim · Accepted Answer

Hi,&nbsp;Anonymous&nbsp;Please correct me if I wrongly understood your question.Please check the below picture if it is what you are looking for.The link (sample pbix file) is down below, and the DAX measure is written in the pbix file.&nbsp;&nbsp;&nbsp;https://www.dropbox.com/s/ddphvu7eutfylc1/Walter.pbix?dl=0&nbsp;&nbsp;Weighted Value =DIVIDE (SUM ( Weights[Weight] ),CALCULATE ( SUM ( Weights[Weight] ), ALL ( Weights ) ))* SELECTEDVALUE ( ValueSelect[ValueSelect] )&nbsp;Hi, My name is Jihwan Kim. If this post helps, then please consider accept it as the solution to help other members find it faster.

Forum Discussion

How to create a measured column by disaggregating a value based on weights listed in a column

2 Replies

Related content

Weighted Average Measure

Disaggregating cumulative data into hourly figure

Calculating Weighted Sales

disaggregated Data

Weighted Average Total Measure