Forum Discussion

danielsouza's avatar
danielsouza
Icon for Helper III rankHelper III
8 years ago
Solved

Stacked column chart is not working

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

 

 

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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's avatar
      danielsouza
      Icon for Helper III rankHelper III
      8 years ago

      Yes! Worked perfectly!!! Thanls a lot! :catvery-happy: