Forum Discussion

Frequent Visitor

7 years ago

Solved

Summerized Values by Group

Hello, i would like summerize Value "LeadTime" when "Element_ID" is the same. Can anybody help me to fix my issue ?

Community Champion

7 years ago

What exactly result do you need?

If you need only table Element_ID - Sum of LeadTime this code fr new table should be enough

Table = SUMMARIZE(Table1;Table1[Element_ID];"SumOfLeadTime";sum(Table1[LeadTime]))

I dont see any other planning result

In visuals do not forget to not summarize Element_ID field

Anyway, you can summarize in visuals without any additional tables

Frequent Visitor

7 years ago

Hi az38 ,

i think thats the Code for my request :

Summe =

CALCULATE( SUM ( 'tabel1'[LeadTime] );

ALLEXCEPT ( 'tabel1'[Element_ID]; 'tabel1'[Area] ) )