SUMMARIZE

[MYDATASTORY]

Hi,

Please advice 

I have a table   with Gender and Score, currently, when  I add score I get 400, but I would like to be summarised by gender 

ID	Gender	Score
1	Boys	100
2	Girls	200
3	Boys	100

I want to summarize this will the Gender  so I can get Boys 200 and Girls 200,

Thanks 

[MYDATASTORY]

Thanks
@HotChilli  table of data in the data view. I have a complex model, so I thought this may help.
I have applied SUMMARIZE (<table>, <groupBy_columnName>[, <groupBy_columnName>]…[, <name>, <expression>]…)
summarize(TableA,gender,score,sum(TableA[score]))

[V-pazhen-msft · Accepted solution]

@MYDATASTORY 

It is a good beginning to learn Summarize(), your formula is very close, just remember if you want to create a new column with expression instead the original column, you need first enter a text name "total score", then follow with expression sum(score).

Table 2 = SUMMARIZE('Table',[Gender ],"Total Score",SUM('Table'[Score]))

BTW you can find any dax function in the doc, there are examples at the bottom to show how to use it. 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HotChilli]

Nearly there.

Remove the first score.  Fully qualify the gender with table name.  Give the newly added column a name e.g. "Total".   Correct any syntax errors and it'll work.

If I was describing it I would say "summarize TableA by gender showing sum of score"

[HotChilli]

I am going to encourage you to have a go yourself first. 

Do you want a table visual or do you want a new table of data in data view?  (either way it will involve a sum of the score column)