Summerized Values by Group

[sod3ho]

Hello,

i would like summerize Value "LeadTime" when "Element_ID" is the same.

Can anybody help me to fix my issue ?

[az38 · Accepted solution]

Hi, @sod3ho 

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

[sod3ho]

Hi @az38 ,

i think thats the Code for my request :

Summe =

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

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