Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Countif with Multiple Conditions
09-21-2022
03:20 AM
Hi, Consider a table
Date | ID | Type |
21/09/2022 | A | S |
21/09/2022 | A | B |
21/09/2022 | B | S |
21/09/2022 | C | S |
Need a measure to calculate the distinct count of ID if there is only Type = S date wise
3 REPLIES 3

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-21-2022
03:31 AM

It counts other IDs as well. I need only the Distinct Count of those IDs containing Type = "S" only not other than "S"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-21-2022
03:26 AM

Try this:
Count = CALCULATE(DISTINCTCOUNT(Table[ID]), Table[Type] = "S")
Then put it in a table together with the date field to see by date.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-21-2022
03:59 AM

For Example:
If the ID has 2 entries containing Type "S" & "B" then it should be excluded from the required distinct count
If the ID has 2 Entries containing Type "S" & "S" then it should be counted

Helpful resources
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
72 | |
66 | |
34 | |
25 | |
22 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
96 | |
94 | |
58 | |
45 | |
42 |