cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Sum depends on filter in other column with district vale

 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

11 REPLIES 11
Frequent Visitor
 S2 2 Fail S5 5 Fail S12 12 fail 19
Frequent Visitor
 S2 2 Fail S5 5 Fail S12 12 fail 19

i want sum as 19

Super User

I have taken this data

Try this

I hope this works.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Frequent Visitor

My data have repated item

Frequent Visitor

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
Super User

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.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Frequent Visitor

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.

Solution Sage

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

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

If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Frequent Visitor

I want distict T1.

Solution Sage

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

If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Super User

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

Don't forget to give thumbs up and accept this as a solution if it helped you!!!