Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Vishwamber
Frequent Visitor

Sum depends on filter in other column with district vale

T1t2t4
S11pass
S22Fail
S33pass
S44pass
S55Fail
S66pass
S11pass
S88pass
S22Fail
S1010pass
S33pass
S1212fail

 

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

 

 

11 REPLIES 11
Vishwamber
Frequent Visitor

S22Fail
S55Fail
S1212fail
 19 
Vishwamber
Frequent Visitor

S22Fail
S55Fail
S1212fail
 19 

i want sum as 19

 hi @Vishwamber 

 

I have taken this data

Uzi2019_0-1711091870713.png

 

 


Try this

Uzi2019_0-1711091785164.png

 

I hope this works.

 

 

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

My data have repated item

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

S22Fail
S55Fail
S1212fail
 19 

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!!!

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.

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!




I want distict T1.

manikumar34_0-1711091884905.png

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!




Uzi2019
Super User
Super User

HI @Vishwamber 

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!!!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.