Forum Discussion
Count and Sum shows wrong results
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.
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:
2 Replies
v-zhangtiCommunity Support
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.
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: