Forum Discussion

AA622's avatar
AA622
Helper II
3 years ago

Using Sum function and/or field in table

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?

1 Reply

  • rubayatyasmin's avatar
    rubayatyasmin
    Community Champion
    3 years ago

    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.