Help with % Mix which then becomes recursive

[Anonymous]

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!

[v-lid-msft]

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]

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.

[mwegener]

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]

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]

Hi @Anonymous ,

did you solve your problem?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[mwegener]

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.