Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Summary Table

Hi I've the following table. I'm trying to get a summary of this table where i get things grouped by Doc# and to sum the income next to each Doc#   Doc# Income Person 902 $900.00 S 87...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    Hi Anonymous 

    Thanks for reaching out to us.

    please try this dax code,

    new table = SUMMARIZE('Table','Table'[Doc#],'Table'[Person],"sum",SUMX('Table','Table'[Income]))

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

vanessafvg's avatar
vanessafvg
Community Champion
3 years ago

is your income a text field data type or a decimal data type?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Decimal

    • vanessafvg's avatar
      vanessafvg
      Community Champion
      3 years ago

      are you able to share your file?

       

      firstly what is the purpose of what you are doing, would a matrix visual work?

      are are you specifically trying to get a summarised calculated table?