Row context is not applied correctly on a numeric field

In the view we have values with respect to different groups but whenever we are taking sum for that field it was showing incorrect values.Also we use SUMX function but it was incorrect values and we checked in excel so in excel it was showing correct value and in power BI it was showing incorrect.Please suggest me any solution.We are getting incorrect count in power BI ,as I mentioned in a snippet before summarizing there are 50 rows but when we are summarizing to count I am getting 226 count in power BI,because of that whenever I am sum the records so it was showing incorrect value in total.