Aggregate values by a distinct identifier in Power BI using DAX

[cenk_yildiran]

Hi I have asked a question on Stackoverflow:

https://stackoverflow.com/questions/75791253/aggregate-values-by-a-distinct-identifier-in-power-bi-u...

[Greg_Deckler · Accepted solution]

@cenk_yildiran In addition to the answer on Stackoverflow, you could do this:

Measure = 
    VAR __Table = DISTINCT(SELECTCOLUMNS('Table',"__GroupNo",[group_no],"__revenue",[revenue]))
    VAR __Result = SUMX(__Table,[__revenue])
RETURN
    __Result