Managed to eventually solve it...and here's the answer in case anyone else ever has anything similar.
Instead of going through the table calculation menu, insted create a normal custom measure.
Use a formula like this:
1-(RUNNING_SUM( [Count of distinct customers] )/ TOTAL([Count of distinct customers]))
and format as a percentage.
At least it seems to work in the few examples I tested!