Hi!

I'm trying to calculate a field in order to have the percent of total.

I'm working with two measures: AGG (Population) and SUM (Volunteers)

My first attempt was CountD(volunteers)/population and it says calculation is valid, but then when I bring it over to my measure values it says "cannot blend the secondary data source because one or more fields use an unsupported aggregation".

The population is a COUNTD of a dimension of ID numbers.

I've also tried

COUNTD([Volunteers])/COUNTD([Population])

I need this measure so I can have percentage of participation among multiple types of fields: staff level, department, office, etc.

Thanks for any and all help!

Rylan