Aggregate values by a distinct identifier in Power BI using DAX

Question

Here my table:

When I create a summed table by group_no I have below table in Power BI:

However, this is what I would like to have:

So, what I would like to get is total revenue by unique project_no on Groups (group_no).

Answer 1

Here you go:

aggregated_revenue = 
VAR tbl = SUMMARIZE('Table', 'Table'[project_no], 'Table'[revenue])
RETURN SUMX(tbl, 'Table'[revenue] )