TOTAL Qualifier with Alternative Dimensions

[dselgo_eidex]

Hello, I am having a problem with using the TOTAL qualifier on a chart that makes use of different alternative dimensions.

Basically, I have a stacked bar chart that is showing demographic information for a population. I want to show the percentage breakdown of the population by different dimensions (e.g. Ethnicity, Gender, etc.).

My expressions for this chart is:

count([Person]) / count(TOTAL<[Ethnicity]> [Person])

This gives me the ideal behavior for the chart. The issue is when I introduce alternative dimensions. For example, the following chart where the dimensions are switched:

Because the TOTAL qualifier is still excluding <Ethnicity>, my chart is not behaving how I want it to. Basically, I want to be able to set the expression to something like the following:

count([Person]) / count(TOTAL<["X-axis Dimension"]> [Person])

Does anybody know how I could accomplish this?

[dselgo_eidex · Accepted solution]

Figured it out. Have to use GetObjectField(0)

count([Person]) / count(TOTAL<$(=GetObjectField(0))> [Person])

[Tyler_Waterfall]

Thanks for posting. Helped me today.