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

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.