Forum Discussion
MYDATASTORY
Resolver I
Resolver ISUMMARIZE
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 2...
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
Community Champion
Community ChampionI 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)