Forum Discussion
SUMMARIZE
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
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.
4 Replies
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)
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.
