SUM OF MAX VALUE BY LATEST TRANSACTION DATE

[ambresameer]

Hi,

Below is the table which I am using in my report and I am facing challenges while trying to calculate the SUM of MAX 't_mauc_1' value by latest 't_trdt' column ( The datetime may remain same or different even if the values in the 't_mauc_1' column are different ). So in this case my output should be as in the second screenshot.  Is there a way to handle this in DAX, I am new to DAX and need help on this one ?

Thanks

[ambresameer]

I tried the measure but received the below error. 

[amitchandak]

@ambresameer , Try a meausre  like

sumx(values(table[t_item]), calculate(lastnonblankvalue(Table[t_trdt], max(Table[t_cpcp]))))

[ambresameer]

I tried the measure but received the error instead after using that in the visual. You can see that in the above screenshot.