Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper II
Helper II

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?

Super User
Super User

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.  

Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.