March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
S2 | 2 | Fail |
S5 | 5 | Fail |
S12 | 12 | fail |
19 |
S2 | 2 | Fail |
S5 | 5 | Fail |
S12 | 12 | fail |
19 |
i want sum as 19
hi @Vishwamber
I have taken this data
Try this
I hope this works.
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.
S2 | 2 | Fail |
S5 | 5 | Fail |
S12 | 12 | fail |
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.
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.
Proud to be a Super User!
I want distict T1.
It will be distinct when you display it on the visual. You can either use measure or use Visual filter to achieve the same.
Proud to be a Super User!
HI @Vishwamber
can you share you expected ouput in excel by typing what do you want??
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
92 | |
86 | |
77 | |
49 |
User | Count |
---|---|
166 | |
149 | |
99 | |
73 | |
57 |