I'm not really following what you're trying to accomplish. if you hide everything that doesn't have an X in it and then you want the % of visible cells with an X in it, isn't that always going to be 100%?

also, based on your sample data if there is anything in the cell it's an X, won't that also always calculate 100%