The result after creater DAX SUM function
Maybe I missed some steps or the system has been updated. But i have also ensured the proper relationships between tables.
I am trying to sum the total score by the category. But it resulted in the total scores of all categories.
This is the DAX that I have made
Total Score = sum(reaction_type[score])
I was expecting my DAX to produce the result where it would indicate the total score for each category.
@Darryl Rusli, Try Grouping the category and then use sum().