1 of 1 people found this helpful
A lot of the answer to this depends on the structure and content of your data. If you can attach a sample packaged workbook (.twbx), we could give you a more definitive answer. If you have confidential data, please see Anonymize your Tableau Package Data for Sharing |Tableau Support Community.
The biggest question is, what is in your [Participation Rate] field at the row level? What you show appears to be aggregated. Is it not? If [Participation Rate] is already calculated and stored on each row, then you probably don't want to sum it. You might try MIN(), MAX() or AVG(). If [Participation Rate] is a calculated field, then you may want to try changing it to a Level of Detail (LoD) calculation. Which is appropriate here depends entirely on your data.
AVG() worked! Thank you!
Glad that worked for you.
FWIW, if the value is calculated externally, and is the same for every row in the partition, then MIN(), MAX(), and AVG() will all return the same value. e.g. if the [Participation Rate] for every row is 42, then MIN() is 42, MAX() is 42 and AVG() is 42. And ATTR() is 42 as well.