Related Table grouping sum

[vitinho]

I'm using some related tables to create a report, the left most table has the values sold, and the right most table has the information which I want to group by. Power bi isn't able to create the sum or the count by itself and don't give me the option to use the calculate function, Any one knows what is happening?
The DAX CALCULATE function is not avaiable when I'm trying to create a calculated column, only avaiable when creating a measure, is it related with my problem?

[Eric_Zhang]

@vitinho

To have a better understanding on the situation, could you please upload you pbix? You can mask the sensitive data before uploading.