Hello,
I am writing this question in order to solve a problem that occurs to us after the the value allocation process. The problem is that after allocating the values, the source row changes its measure value to 0 instead of disappearing. Also, a destination row appears with the value of the measure that was previously in the source row.
I am going to explain this problem with an example. We have the following table:

We want to allocate values in the State California to the Country USA and values in the State Andalucia to the Country Spain. This would be the resulting table:

Instead, zero values appear in the table duplicating the initial rows:

How could we delete/hide rows with zero values? We do not really need them anymore.
Thank you so much in advance and sorry for the amount of questions this week!
Elisa