Total Value Increased Incorrectly

[Anonymous]

In the report above, "Professional And Technical Services"  column total is different and in the below table "Order $" total is different. It should result the same. In SSMS, i have run the queries where the "Order $" column is taking round off values and some are incorrect values for which it is showing incorrect total value in "Order $" column. How do i correct this?

[Anonymous]

Hello,

 In the elow table, i have kept those both columns side by side to understand the number difference. I feel that KPI_Achievement is the column which has the difference and order_price column is correct. The above one is the measure for KPI_Achievement column. Now i dont know how to rectify the total value mismatch .

I've pushed the data in an excel file to undertsand the exact difference of the numbers. Hope this will help you understand where the exact issue is.

[v-zhangti]

Hi, @Anonymous 

Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance. What is the correct value you expect?

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.