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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.