Using Sum function and/or field in table

[AA622]

I am having this issue with inventory quantity in our Inventory Transactions table.

I created a simple Sum function to show the qty. 

Measure.Qty = SUM(InventTrans[Qty])

To compare I inserted the field from the same table

The correct value is 1300 but in the measure I get 2600. Why am I getting the duplicated value?

Its all coming from one table so there is no relationship issue. any idea?

[rubayatyasmin]

Hi, @AA622 

1. Did you check for duplicated values in your table? If not you might want to check it. 
2. You can try a card visual to see your result properly instead of a table visual. In the table, visual data gets filtered
If you want to sum distinct values only. You might want to use distinct function with SUMX

Did this solve your problem? If yes, hit 👍 and accept this answer as a solution.