Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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??
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
83 | |
82 | |
67 | |
49 |
User | Count |
---|---|
135 | |
111 | |
100 | |
65 | |
62 |