Forum Discussion
Solved
Countrows with filters
I am trying to count the rows for an ID where they only have a specific code.
Example: If I am looking to count the IDs that only have code D how would I count just that row. In this case the count would be 1 because only ID 3 has code D only.
| ID | code |
| 1 | M |
| 1 | D |
| 1 | L |
| 2 | D |
| 2 | M |
| 3 | D |
Simple enough,
9 Replies
Just incase if you want to return ID's that only have one instance of "D"
Table_1 = VAR _Table = SUMMARIZE( 'Table', 'Table'[ID], "Codes", DISTINCTCOUNT( ( 'Table'[code] )), "Codes_D",COUNTROWS( FILTER( 'Table', 'Table'[code] = "D" )) ) RETURN FILTER(_Table,[Codes]=[Codes_D])
