GENERATESERIES with dynamic EndValue

[samdthompson]

Hello, I have multiple paramterers I want people to be able to change which act as weigthings for a series of measures, but never add to more than 1.

I want to make something along the lines of:

param1=GENERATESERIES(0, 1, .05)

param2=GENERATESERIES(0, (1-SELECTEDVALUE(param1), .05)

param3=GENERATESERIES(0, (1-SELECTEDVALUE(param1)-SELECTEDVALUE(param2), .05)

...

I didnt think it would be as hard as it is. Any ideas on how to do this?

Cheers,

Sam

[AlB]

Hi @samdthompson 

Can you try to explain a bit more what you need? I don't quite get it. An example based on your data would be useful. 

[samdthompson]

The first parameter is made with GENERATESERIES(0, 1, .05)

The second and subsequent need to be made with the EndValue being 1-sum of the selected values of the previous generated series. 

[v-eachen-msft]

Hi @samdthompson ,

I think you want to create parameters by previous value automitically. Is it right?

[samdthompson · Accepted solution]

Correct. Is there a way to do that?

[v-eachen-msft]

Hi @samdthompson ,

There isn't a way to do it currently in Power BI. However, you can post your idea here  to make it a feature of Power BI in the future.