New Column - Sum of values calculated for the all days Production ( DAX Support)

[Gokul_G16]

Hello Cummunity,

@Arul @prakashc  

Here i'm atthaching the Sum of value calculation for based on the ID the entire value should be the total sum values.

Snap for your quick reference, 

As attched table like seems my data set. i want to sum of the values like MY request column -

It contains based on the ID number have been calculated sum of values.

Can you please suggest to make the DAX logics..

Regards,
Gokul.

[Kishore_KVN · Accepted solution]

Hello @Gokul_G16,

You have to create a calculated column using ALLEXCEPT to achieve this requirement. 

Please refer below screenshot for the DAX expression and the result 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Gokul_G16]

I'M Good. Thanks 🙂

Regards,
Gokul

[Idrissshatila]

Hello @Gokul_G16 ,

Did you try to put them in a matrix were the ID field is the first in rows so it will give you a summation of all the values related to this one ID.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin