cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sod3ho Frequent Visitor
Frequent Visitor

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 ?

 

2019-03-25_13h51_32.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
az38 Regular Visitor
Regular Visitor

Re: Summerized Values by Group

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

2 REPLIES 2
Highlighted
az38 Regular Visitor
Regular Visitor

Re: Summerized Values by Group

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 Frequent Visitor
Frequent Visitor

Re: Summerized Values by Group

Hi @az38 ,

i think thats the Code for my request :

 

Summe =
CALCULATE( SUM ( 'tabel1'[LeadTime] );
ALLEXCEPT ( 'tabel1'[Element_ID]; 'tabel1'[Area] ) )