Sum or Sumx based in distinct count another column same table

[Anonymous]

Hi Expert

Need a dax measure to give me the distinct count based in ListID and the sum of the PlannedProcedureTime

see sample data

ListID	PlannedProcedureTime
7659	120
7659	120
7647	30
7647	30
7700	60
7700	60
7700	60
7700	60
7700	60

[ddpl]

@Anonymous Could you please share expected result in sample table

[Anonymous]

Expected Result

istID	PlannedProcedureTime
7659	120
7647	30
7700	60

[ddpl]

@Anonymous try this

[Anonymous]

Hi thanks - but can we do this as a meseaure as i need to use it for other visuals and metrics. please.

[ddpl · Accepted solution]

@Anonymous try this

Measure = max(Yourtable[PlannedProcedureTime])