Summarize Column - TRICKY (show the over sum/count for each data point for each material_id)

[Anonymous]

Hi Experts

i have the following DAX as a starter for 10. 

Table = ADDCOLUMNS(
    SUMMARIZECOLUMNS(PMS_PARTS[Product],PMS_FINANCIAL_PDS[ROLL12_COMPLETE_PDS_IND],PMS_FINANCIAL_PDS[Month Start]),"CountComplaints",[PMSComplaintsMN],"p-value",[p-value],"Trend",[__trend],"Significance",[Significance Y])

I want to show in the CountcComplaints column the overall sum in each row of data for the same Material_ID for period Y so for 722039672 as shown below (see image) i want to show 419 as opposed to 40, 36,43 and so on for each dat that relates to period Y,X and W (ps the sum for X and W - will be different as x is 24month and W is 36 months)

sample file here, you can create a new table in the sample file.

https://www.dropbox.com/s/jj62h2vxtepm5yd/Sample__Test%281%29.pbix?dl=0

[Greg_Deckler]

I don't see the image. Can you post sample data as text and expected result? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Expected Result 419 for each data point which is the sum of the above.