Forum Discussion

DarSz's avatar
DarSz
Helper I
5 years ago
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 ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago
    How many ids measure :=
    COUNTROWS(
          SUMMARIZE(
              FILTER('Table', 'Table'[value] = "true"),
                    'Table'[id])
    )
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago
How many ids measure :=
COUNTROWS(
      SUMMARIZE(
          FILTER('Table', 'Table'[value] = "true"),
                'Table'[id])
)