Forum Discussion
Solved
Sum of (calculated measures (conditional measures))
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...
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.
jdbuchanan71
Super User
Super UserYou 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.
Thank you😊. It worked.