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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Hydrarian
Helper I
Helper I

SUM measure double the result

Hi, I have several rows with some column values like quantity and net amount, and other text column that are the same for all rows.

I wanto to sum up the value and the net amount column grouped by a column value, like "item id", but when I create the measure 

SP_Net amount = SUM('F - Sales packing slip'[Net amount in company currency]) and 
SP_Quantity = SUM('F - Sales packing slip'[Quantity]) the total value is doubled.
Here is two images: first one without the measure (with the simple rows field), and the second one with measures (the total value gets doubled).
asddsa.PNG2dsdasdads.PNG
 

 

 
4 REPLIES 4
Tahreem24
Super User
Super User

@Hydrarian ,

If you want  create sum based on specific group like Item_ID so use the below measure:

Measure = CALCULATE(SUM(TableName[Net_Amount]),ALLEXCEPT(TableName,TableName[ItemID]))

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
amitchandak
Super User
Super User

@Hydrarian , I can not see any total field in the second image. In rhe first image you have used measure. And in the second one the column seems to be not summarized

Hi, maybe I explained it in the wrong way. These are all the rows I want to summarize:

porcatroia1.PNG

porcatroia2.PNGThis is the row that summarize them all with the measures:

SP_Net amount = SUM('F - Sales packing slip'[Net amount in company currency])

SP_Quantity = SUM('F - Sales packing slip'[Quantity]) 

. I'm not talking about automatic total, I'm talking about sum more rows in one, such as a group by in sql. The Net amount should be 1152,45 and the quantity should be 197000, exactly the half.

The measure I used 

Hi, @Hydrarian 

 

I can’t see the problem from the data you provided, Is there a relationship in your table, is there a date table? 

Can you share some sample fake data? So we can help you soon.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.