Thought this might be helpful to this forum as its a fairly common Government issue.
We were grappling with an issue where we had 3 columns of data representing 3 separate demographics. The data would become identifiable if the total of either of the 3 columns totaled 100%.
The solution has the added complexity of using the color mark that has been used, and then using this to calculate the equation.
Looking at the data scenario above, the % third measure is 100%, so we wish to null out columns A, B and C like this:
% first measure
% second measure
% third measure
Here's the solution in Tableau:
Retrieving data ...