Sum of (calculated measures (conditional measures))

[Mad890]

Hello BI Fam,
I have a problem in calculating the total of calculated measure. The below sc shows the table, Lateslam_DPMO and Late_slam_penalty are calculated measures. The conditional measures are also posted in the pictures. 
Now i want to calculate the sum of those calculated measures. I have applied the CALCULATE func but it is not giving me the right answer. It would be appreciated if some one from the family understand this and help in finding the solution.

[jdbuchanan71 · Accepted solution]

@Mad890 

You can use a SUMX iterator to get you the total you are looking for I think.  It takes a list of values (looks like the CW field in your case), calculates an amount then sums up each row.

Late_Slam_Penalty_Total = SUMX ( VALUES ( 'YourTable'[CW] ), [Late_slam_penalty] )

You would need to change the name of the table / field in this part

VALUES ( 'YourTable'[CW] )

to match your model.

[Mad890]

Thank you😊. It worked.