To create a calculated column in MAIN_TABLE that sums the AMOUNT from the related DATA_TABLE , grouped by value in the color column . Here's an example of how to create the calculated column : Total_Amount_By_Color = CALCULATE( SUM(RELATED(DATA_TABLE[AMOUNT])), FILTER( DATA_TABLE, DATA_TABLE[color] = MAIN_TABLE[color] ) )