How can I make the percent of column total add up to 100% even if the filters change?

[ThePiecesFit]

I made this dummy table to make it easy for anyone to help me:  
https://drive.google.com/file/d/1-iye11nvx4cJK3lKXc6U97T-4gys9qAP/view?usp=sharing

Goal: to calculate percent of column total. And if any of the filters change, to keep calculating percent of column to 100%. 

As you can see below, when I change the filters, the percentages no longer add up to 100%. I've read dozens of similar questions on this forum and haven't found the answer that applies to me. Please help!

[ThePiecesFit · Accepted solution]

I got someone at my company to help. The solution was to use the "100% stacked column chart" visualization. There's no need to create a measure, I just selected that visualization and put the count of opp ID in the Values section and voila! 

[Greg_Deckler]

Would have to see your measures or how you are calculating those %'s. Probably has to do with potentially needing to use ALLSELECTED instead of something like ALL. Almost definitely involves your own measure versus the default, built-in methods of doing that.

[ThePiecesFit]

Hi Greg. I included a link to the dummy file. And the formula I'm using is on the top left of the GIF that I embedded. Thanks.