Stacked column charts with two data points

[paulotv]

Hi there, I need some help. I am trying to create a stacked column chart that has two related data points on it as below:

I can easily show the by category split by value by gender. But I want to include the data point for the ratio of males to female by category, is there a way to include this? Or is there a better way of displaying this data?

Thanks in advance.

Paul

[v-chuncz-msft]

@paulotv,

You may add a measure as shown below.

Measure =
DIVIDE (
    CALCULATE ( SUM ( Table1[value] ), Table1[gender] = "Male" ),
    CALCULATE ( SUM ( Table1[value] ), Table1[gender] = "Female" )
)

[paulotv]

Hi there & thanks for your help, I created the measure but when I placed it in the value field of stacked column chart is just divided the gender balance into 50/50, which is wrong.

Not sure if the measure itself doesn't do the job or whether its my use of it.  When I use the measur in the chart it displaces the value field I am using there.

Can you help?

Cheers

Paul