Numeric column would not sum by category in table visual (no sigma sign shown in Fields pane)

Hello,

I found a solution that worked for me and might help you as well. Navigate to the Model View tab on the left-hand side of your Power BI report screen. Click on the semantic model to view its properties on the right-hand side, as shown in the picture below. Then, toggle the "Discourage Implicit Measures" button to "No." This should resolve the issue.

If this solution helps, please mark this post as the solution. Thank you!