Forum Discussion

samdthompson's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
6 years ago
Solved

GENERATESERIES with dynamic EndValue

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: ...
Need Help
  • samdthompson's avatar
    samdthompson
    6 years ago

    Correct. Is there a way to do that?

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
6 years ago

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's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi samdthompson ,

     

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

     

    • samdthompson's avatar
      samdthompson
      Icon for Memorable Member rankMemorable Member
      6 years ago

      Correct. Is there a way to do that?

      • v-eachen-msft's avatar
        v-eachen-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        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.