Forum Discussion
Solved
Distinctcount based on another column
Hello, I need help with a measure. I have following table:
| id | value |
| 1 | true |
| 1 | false positive |
| 1 | false |
| 2 | false positive |
| 2 | false |
| 2 | false |
| 3 | true |
| 3 | true |
| 3 | true |
I need to count how many Id's has at least one true in column Value. In my example the answer is 2 (Id 1 = 1 true, Id 2 = 0 true, Id 3 = 3 true). Can anybody help me with this task?
- How many ids measure :=COUNTROWS(SUMMARIZE(FILTER('Table', 'Table'[value] = "true"),'Table'[id]))
1 Reply
- How many ids measure :=COUNTROWS(SUMMARIZE(FILTER('Table', 'Table'[value] = "true"),'Table'[id]))