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 moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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??
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
User | Count |
---|---|
93 | |
92 | |
84 | |
82 | |
49 |
User | Count |
---|---|
145 | |
142 | |
111 | |
71 | |
55 |