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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
chris0202
New Member

Need help to create a sum for last cell, which summarize the positions before

Hi guys I am a problem, I Desktop which contain mutiple Artcle Numbers. For each Article number there are costs and the sales volume. The Reult muss return in a spcial cell benefit it. 

 

Give you an example: 

 

1 sales Volume: Chcoclate 10

                          Banana 12

                          Milk 8

 

2 Costs:             Chocolate 5

                         Banana 4

                         Milk 6

 

The result must come out in the same column. Which means i have to summarize the column within the coulmn. I need to be able to filter Article Number, there more than numbers. 

 

The Result has to come out in the same column. Which i have sum the Column in the last cell of the column. Do anybody have an idea?

4 REPLIES 4
chris0202
New Member

Sales volume - costs. The result must accpear under the figures. You can work with conditional column. The result must be fitered later.  

chris0202
New Member

 

chris0202_0-1702216702759.png

 

chris0202
New Member

How about i upload the problem?

Kishore_KVN
Super User
Super User

Hello @chris0202 , Your requirement is not clear can you please explain it in detail. 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors