Variation on the total biased in a matrix

[Syndicate_Admin]

Good people, I recently started playing with Power Bi with a random dataset, but something that occurred to me and I wanted to do would not be coming out, I tell you:

This is my matrix along with some filters I created:

For now, what I did was that depending on which filter chooses the matrix will show me different data, for example: currently the units sold are shown (whole column), the variation with respect to the previous month ( monthly variation column) and finally, the % that represents the data on the monthly total (% per total column ). (if I chose GR it would return the values corresponding to it).. and my problem comes with respect to the latter. What I did was simply copy the calculation of the entire column, put it in "values" of the matrix and have it displayed to me as "Total column percentage".
So far so good, give what I want, but now I want to remove that last column and make all the data appear in the two (integers and variations); then what I am looking for is that, creating another filter to select, I appear in, for example the column integers, the monthly product / total data, that is, that in for example the FIla of Snacks the result of 1501/29801 appears

Playing in separate tables I did not achieve anything, the most I did without being thrown error was that I give the sum of the general total value:

Any help is welcome and thank you very much.

[Syndicate_Admin · Accepted solution]

Well, I was lucky and managed to get it out, I was using the CALCULATE function very badly. In the end it was necessary to do:

calculate(midato, ALLSELECTED('table'[column]))