want to replace the field in the matrix

[Anonymous]

Hi, I have a matrix of values which works perfectly.  The text is in black Font.
I want to be able to calculate the breakdown of all second leve, third level, etci in the matrix.  I can do that as you can see in the red font.
But I can't replace the existing percent column in red, just add the column in red as an additional column.

How do you then replace the existing pecent with the new version of the field in red? I want the values to calculate the percent by the grouping it's currently in, by defaut it groups and then calculates against the total amount.  Is there a trick where I can hide the existing percent in black and replace with the percent in red?

[Anonymous]

I appreciate the attempt.  I however got the answer I needed from an external source.
Thanks everybody!

[Anonymous · Accepted solution]

Hi @Anonymous,

Any update for this? Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.