Forum Discussion
SUMMARIZE
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.
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]))
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"
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.
