Forum Discussion
Difficult comparison
Hi,
I have a dataset like:
| ID | Code | Check1 | Check2 |
| 1 | 100 | T | F |
| 1 | 100 | T | F |
| 1 | 100 | T | F |
| 1 | 200 | F | T |
| 1 | 200 | F | F |
| 2 | 100 | T | T |
| 2 | 200 | T | F |
| 2 | 200 | T | F |
| 3 | 100 | T | F |
| 3 | 200 | T | F |
If Code is 100, Either Check 1 or Check 2 is T (in every record), then overall check for code 100 with be "T" for that ID.
If Code is 200, then atleast one row should have "T" in check 1 or check 2, this will make code 200 as "T".
Now, rolling up to ID level, if code 100 and code 200 is "T", ID is "T" else "F".
How can I calculate this? Either a summary table or measure to calculate count of IDs being T/F will work for me.
3 Replies
Hi Anonymous,
Can you please share the expected result for the data shared in the question
Hi Anonymous,
If Code is 100, Either Check 1 or Check 2 is T (in every record), then overall check for code 100 with be "T" for that ID.
If Code is 200, then atleast one row should have "T" in check 1 or check 2, this will make code 200 as "T".I'm still a little confused about your requirement. Is the two centence above your descrption for your data table?
And your requirement is to check if the ID is T or F?
Could you share your expected output as visual so that we could understand your requirement better?
Best Regards,
Cherry
