Stacked column chart is not working

[danielsouza]

Hi

I have these tables:

And I want to plot this chart:

The black area is ok, but the red is returning 32, the sum of Geral column in table Satisfação Interna, I need the specific values for each name, for example Carlos Cunha is 7 not 32

 Thanks a lot

Daniel

[v-yulgu-msft · Accepted solution]

Hi @danielsouza,

Make sure there existing a one to many relationship between two tables.

Create below measure and add into to stacked column chart.

val1 = CALCULATE(SUM(Table1[Val1]),RELATEDTABLE(Table2))

Best regards,

Yuliana Gu

[danielsouza]

Yes! Worked perfectly!!! Thanls a lot!