cancel
Showing results 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

Anonymous
Not applicable

## Summing up the production time for individual products

Hello people,

I need a DAX command that adds up the individual production times of different production steps for different products and outputs them summarized in a column.

Here in the table I have created a small schematic example.

Thanks a lot for your help!

 Product Protuction time (for this step) [h] Total production time 1 3 10 1 5 10 1 2 10 2 4 8 2 4 8 3 3 9 3 6 9

Greetings Lukas

1 ACCEPTED SOLUTION
Super User

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

4 REPLIES 4
Anonymous
Not applicable

Now I have tried to calculate the individual production steps more precisely. Can I add another filter condition to the filter function to get the calculation as shown in the table?

If tryed it with:

CALCULATE(SUM('Tabel1'[Protuction time]), FILTER('Tabel1',CONTAINSSTRING('Tabel1'[Production Step],"M2"),ALLEXCEPT('Tabel1', 'Tabel1'[Product]))

With this, all M2 production steps get summed up.

Thanks for the help so far!

 Product Production Step Protuction time Total production time of M2 1 M1 3 3 1 M1 4 3 1 M2 2 3 1 M2 1 3 2 M1 3 4 2 M1 3 4 2 M2 2 4 2 M2 2 4 3 M1 5 5 3 M1 2 5 3 M2 4 5 3 M2 1 5
Anonymous
Not applicable
CALCULATE(SUM('Tabel'[Production time]), ....

Is it possible to do it with a CALCULATE and SUM comand?
Super User

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Super User

new table =
SUMMARIZECOLUMNS (
Data[Product],
"@total production time", SUM ( Data[Protuction time (for this step) [h]]] )
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Announcements

#### 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 Monthly Update - June 2024

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

#### New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors