Sum of a calculated column incorrect

[Anonymous]

Hi community,

I am stuck on the following issue:

'Wait time for contact' is a calulated column. 'Wait time for contact_total' is a measure that sums up the column 'Wait time for contact', which gives incorrect value 51, it should be 140.

My pbi file: https://1drv.ms/u/s!Ag919_pO_UKrgQwdzaPqiwm7NcmX?e=3JwngV

Hope someone can help me figure out whats going on here.

Many thanks

[amitchandak · Accepted solution]

@Anonymous , Change the measure like

Wait time for Contact_total = 
CALCULATE(sumx(  VALUES ( Table1[Case_id]), CALCULATE ( max (Table1[Wait time for Contact]) ))
)