Sumx a column's value only once based on business logic

[yios]

Hi all,

I have a question regarding the following requirement.

First of all data is like below

Day	Duty	Task	DutyStarts	DutyEnds	DutyDurationHrs
1	D1	T1	9:00	11:00	2
1	D1	T2	9:00	11:00	2
2	D1	T1	14:00	19:00	5
2	D1	T2	14:00	19:00	5
2	D1	T3	14:00	19:00	5
3	D1	T1	9:00	11:00	2
3	D1	T2	9:00	11:00	2

In a visual table there will be the column Duty and then i want to display a measure which will show sum of DutyDurationHrs for all Days that this Duty exists. 

Regarding above dataset i would like to show

Duty      DutyDurationHours

D1         9

I mean that for each Day that this Duty exists, i want to extract the value of DutyDurationHrs only once and finally to sum all of them (for example in Day1 -> D1 duration was 2 Hrs, in Day2 -> D1 duration was 5 Hrs, in Day3 -> D1 duration was 2 Hrs, 

[Zubair_Muhammad · Accepted solution]

@yios 

Try this MEASURE

Measure =
SUMX (
    VALUES ( TableName[Day] ),
    CALCULATE ( AVERAGE ( TableName[DutyDurationHrs] ) )
)

[yios]

Thanks @Zubair_Muhammad 

It works!