ASK HELP - How To Getting Sum with distinct methods

[syaifulefendi]

Hi 

i am asking your help to solve dax here .

i have below table 

TASK NO	COSTING
TASK01	100
TASK01	100
TASK01	100
TASK02	200
TASK02	200
TASK02	200
TASK03	300
TASK03	300
TASK03	300

my goal is to create measure to getting sum of costing each Task with distinct task ( due error system , duplicate detail appear ), instead of this i need to do distinct and do sum calculation.  result like below table 

TASK NO	COSTING
TASK01	100
TASK02	200
TASK03	300

Thanks 
SE

[v-easonf-msft]

Hi, @syaifulefendi 

If your problem has been solved, please accept the helpful reply as solution to close this thread, so that other community members will easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason

[amitchandak · Accepted solution]

@syaifulefendi , Create a measure like

Sumx(Summarize(Table, Table[Task], Table[Costing]), [Costing])