Skip to main content
cancel
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

Reply
AA622
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?
 
AA622_0-1689367793805.png

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

1 REPLY 1
rubayatyasmin
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

Announcements
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.

PBI_Carousel_NL_June

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.