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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

To your visual, drag Doc# and Person and write this measure

Total = sum(Data[Income])

Hope this helps.