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

[Anonymous]

Hi community,

I am struggling with a rather theoretically easy task but not immediate on DAX that has kept me busy for a while.

I need to create a measured column by disaggregating a value based on some weights that are listed in a column.

So, as an example, the value I want to diasaggregate is 100 and the weights are listed in a column as:

Weights

0.3

0.4

0.6

0.3

0.4

The result I am targeting in this example is:

Weights    Values

0.3            15

0.4            20

0.6            30

0.3            15

0.4            20

Any idea?

Thanks,

Walter

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

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.

 

https://www.dropbox.com/s/ddphvu7eutfylc1/Walter.pbix?dl=0 

Weighted Value =
DIVIDE (
SUM ( Weights[Weight] ),
CALCULATE ( SUM ( Weights[Weight] ), ALL ( Weights ) )
)
* SELECTEDVALUE ( ValueSelect[ValueSelect] )

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.

[Anonymous]

HI @Jihwan_Kim,

your solution is actually working. Thank you so much!

Regards,

Walter