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.
