topic Re: Summing up the production time for individual products in DAX Commands and Tips

Summing up the production time for individual products

Anonymous — Tue, 29 Jun 2021 07:46:18 GMT

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

Re: Summing up the production time for individual products

Jihwan_Kim — Tue, 29 Jun 2021 08:22:05 GMT

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

https://www.dropbox.com/s/voqap7cojyjpp7h/keluv4.pbix?dl=0

Re: Summing up the production time for individual products

Anonymous — Tue, 29 Jun 2021 08:36:38 GMT

CALCULATE(SUM('Tabel'[Production time]), ....

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

Re: Summing up the production time for individual products

Jihwan_Kim — Tue, 29 Jun 2021 08:48:30 GMT

https://www.dropbox.com/s/voqap7cojyjpp7h/keluv4.pbix?dl=0

Re: Summing up the production time for individual products

Anonymous — Tue, 29 Jun 2021 10:04:51 GMT

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