How can I calculate the percentage of total rows?

[ACol123]

Hi guys, can anyone tell me how I can calculate the percentage of total rows.
I calculated the percentage on the total of the columns, but I can't calculate the percentage on the rows, what formula should I use? Mainly I can't get the denominator, then the row total without the context of the columns. Thanks to anyone who can help me

[Gabriele_hbto]

By the way, you can also utilize the new visual calculations which, as I've seen (though I haven't tried them yet), should make this process very straightforward

[ACol123]

I'll try, thanks for the advice!

[Gabriele_hbto]

Can't understand what's your issue, try to explain better

[ACol123]

You're right, forgive me!
I want to insert two columns into the matrices that contain the value in the form of a percentage of the total of the columns (e.g. 57,419.41/332,959.20) and in the form of a total on the rows (e.g. 57,419.41/123,988.31). I can't calculate the value of the percentage of the total rows, exactly I can't calculate the denominator that gives me the total rows value of 123,988.31.

[Gabriele_hbto · Accepted solution]

Understood thanks. I think you just need to keep the filter on the color and remove the filter on the company. Same formula as you wrote above but instead of ALL (product color) u should write ALL (dim company table).

If you need further help upload the file or the screenshot of the model view atleast. Otherwise please mark as problem solved.