SUM measure not working properly

[juniorBI]

Hey guys! I'm recently facing an issue regarding a SUM measure. 

I have this dataset in Excel and I want to see the sum by category, as follows (these are the right numbers)

On Power Bi, I did a simples measure "_Sum = sum(mainBase[Paid_Price_Ajust])", but it doesn't seem to work properly. The grand total is right, so is some categories, but 2 of them are not ("Midia Paga" and "Organico"), as follows:

My expected result would be the same numbers from the Excel file. I thought it could be some error importing the base, but when I tried creating a summarize table it worked fine, so I'm out of options (Summarize table below, working properly)

Would appreciate any help!

[amitchandak · Accepted solution]

@juniorBI , Please check excel data is loaded properly. Last time I saw such an issue. there was a data type issue or join issue

[juniorBI]

I figured it out, there was a problem in the relationships, part of the data was duplicated in another sheet. Thanks!