Sum depends on filter in other column with district vale

[Vishwamber]

T1	t2	t4
S1	1	pass
S2	2	Fail
S3	3	pass
S4	4	pass
S5	5	Fail
S6	6	pass
S1	1	pass
S8	8	pass
S2	2	Fail
S10	10	pass
S3	3	pass
S12	12	fail

Hi Team I want to sum of T2 column with disict T1 column and filter of t4 as fail

[Vishwamber]

S2	2	Fail
S5	5	Fail
S12	12	fail
	19

[Vishwamber]

S2	2	Fail
S5	5	Fail
S12	12	fail
	19

i want sum as 19

[Uzi2019]

 hi @Vishwamber 

I have taken this data

Try this

I hope this works.

[Vishwamber]

My data have repated item

[Vishwamber]

You need to exclude repeated item in T1, for an eg s2 is repating 2 times but i want one time. 

S2	2	Fail
S5	5	Fail
S12	12	fail
	19

[Uzi2019]

Hi @Vishwamber 
@manikumar34  and I  given you correct answers but I think you didnt check the screen shot we've shared with you. In screen short there is distinct values of T1. 
I dont know what issue you are facing. 

Please share the screenshot after taking measures. so we can guide you.

[Vishwamber]

No I am getting sum as 21 which is wrong, I will wait for other members for soulution, I think you guys are missing distict calculation.

[manikumar34]

You have S2 repeated twice with failed status, thus it results in 21. 

Measure =

CALCULATE(SUM('Table'[T2]),'Table'[t4]="Fail")

[Vishwamber]

I want distict T1.

[manikumar34]

It will be distinct when you display it on the visual. You can either use measure or use Visual filter to achieve the same.

[Uzi2019]

HI @Vishwamber 

can you share you expected ouput in excel by typing what do you want??