View the original community article here
Last tested: Jul 11, 2019
Explanation
A percent_of_total measure is basically a table calculation, which means it's not run on the database. Therefore, if the row limit is hit, the total can't be properly calculated.
Solution
Increase the row limit to the max (5000).
If you have more than 5000 rows, then this will require a derived table instead.
This content is subject to limited support.