Maximum size subset with given sum

[smpa01]

Hello experts,

I have a data set, e.g. as following

Raw Data={1,2,3,4,5,6,-0.75,-0.25,-1,-1,-3,-3.5,-0.5,-12}

I want to create a subset of this data which would include max number of members where the sum of all those memebrs would equate to 0.

Desired = {1,2,3,4,-0.75,-0.25,-1,-1,-3,-3.5,-0.5}

SUM=0

Any help is greatly appreciated.

Thanking you in advance.

[smpa01]

Hello experts,

Is there any way to achieve this by using DAX? This can be easlily done using R script.

But I can't utilize R script to generate a measure to be displayed on a PBI native viz.

Any help is greatly appreciated.

Thank you in advance.