Sum a column but filter by distinct values in other column

[SophRow]

Hi,

I want to sum the total Working Days for a column, but filter by unique values in the User ID column so in the example below the total should be 180.

Any help greatly appreciated!

Best,

Soph

[SophRow · Accepted solution]

Solved it!

TWD = SUMX(SUMMARIZE('Leave ALL','Leave ALL'[User ID],'Leave ALL'[Working Days]),'Leave ALL'[Working Days])