Distinctcount based on another column

[DarSz]

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?

[Jihwan_Kim · Accepted solution]

How many ids measure :=

COUNTROWS(

      SUMMARIZE(

          FILTER('Table', 'Table'[value] = "true"),

                'Table'[id])

)