Skip to main content
cancel
Showing results for 
Search instead 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

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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