I want to create a measure. that counts all the 'Target Met' and divides that total count by 5. Than that measure will be displayed as a percent for each team grouping. I've tried half a dozen combinations of script with no luck. Thank you for the help. Workbook attached.
Stephen, try this: SUM(IF [% Met (Team)] >= .9 THEN 1 END) / 5