Forum Discussion

bvramilo's avatar
bvramilo
Frequent Visitor
2 years ago

Avoid sum multiple times same value on column

Hi everyone,    I have being problems calculating a total on a Matrix:    I have this structure:    Batch IdBatch Amount Connection 1-N with Component table   Component I...
Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
2 years ago

Hello bvramilo,

 

Can you please try the following:

Total Batch Amount = 
SUMX(
    VALUES(Batch[IdBatch]), 
    CALCULATE(
        MAX(Batch[Amount])
    )
)