Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help with % Mix which then becomes recursive

Hi there, happy holidays everyone.  

Here is the challenge I am facing.  I have a product mix that i am using for a certain month, for example january, then i want to apply a new number for January but apply the product mix percentages that were previously calculated.  I am using measures to calculate the % of total (as in the sample below) but when I apply it to the new value that i would like to spread powerbi calls out a recursive error because i want to replace the original January values with the new values.

 

Is there a way around this?  i tried to create a disconnected table with the percentages housed in them but that didn't work.  I am sure there must be an easy way to solve this.  Thanks for your help!

 

Need Help

6 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi Anonymous ,

     

    look at this.

     

    PBIX

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for this, unfortunately it doesn't solve my issue.  I realize I didn't explain the issue properly.  Instead of a new total January value, i would like a new product spread in the original January column using a fixed value for product D. 


      I have built the %s as measures already, but i almost want to do a "paste value" like we could in excel so that those percentages are locked and not recursive.  Hope my explanation makes sense.

      • mwegener's avatar
        mwegener
        Most Valuable Professional
        6 years ago

        Hi Anonymous 

         

        look at this.

         

        PBIX

         

        If I answered your question, please mark my post as solution, this will also help others.

        Please give Kudos for support.

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,


    Have your issue be resolved?Could you please provide more details about it If it still not be soleved? Please don't have any Confidential Information or Real data in your reply.


    Best regards,

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      hi there, unfortunately this isn't solved.  The issue is that i need to have multiple items calculate off of the mix % then sum them all up again to calculate a new figure.