Modifying measure to a percentage of two summed values

[Cevaro]

Hello,

I have such a problem.
A dashboard is created using the Matrix table.
I use the Measure written in this way, which is on the screenshot below.

However, the problem is that it adds the percentages together as a total. But I would need to modify the Measure so that it also makes a ratio of SUM(Scrap)/SUM(Sales) at the end (marked in yellow) and not the sum of percentages (marked in red).

Is it possible to somehow modify this measure so that it does what I want?

Thank you very much for your help.

[johnt75 · Accepted solution]

I think you can just remove the SUMX( VALUES()) part of your code and just use the divide

[Cevaro]

AWESOME! it works 😄 thank u very much for your help! 🙂