Count and Sum shows wrong results

[anoopjoy]

I need your support for the below issue.

I have connected my excel to power BI and generated graphs. While generating the reports I am facing the below issue:

1. Sum Function: I am calculating man-hours spent on each property, In the below chart "Total man-hours by property" based on the filter, it should show the value as 4 but it shows the wrong value as 6. Please refer to the table below, where the correct value is 2+2 = 4 (total hours spent) is shown; but in the chart, it is showing wrongly. When I make a sum the result is showing wrong with more value and I need your support to fix it. 

2. Count Value: In the below chart name "Count of property visits", here actually it should show the result as 2, but it shows a wrong result as 3. Can you please advise on how to fix it.

I hope I have clarified my query. Looking forward to your support.

[v-zhangti]

Hi, @anoopjoy 

You need to check the source data, are there 3 Amlak HO's? Can you provide simple pbix files? Sensitive information can be removed in advance.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[anoopjoy · Accepted solution]

In the source data, there are only 2 Amlak HO's.

Actually, in the excel file, there were a lot of null values. So I have created a formula and changed all null values to " ". After that, the report was captured correctly. These sensitive data had created issues.

Thanks for your support.

The screenshots with the correct value are mentioned below: