Calculate a measure based on the aggregation of a sales column

[Caldasls15_]

I want to create a measure to distinct count the CLIENT_ID if the aggregation of the sales column is greater than 0.

I used to create a calculated column to bring me 1 if the sales where greater than 0, else it would bring me 0.

So it would look like: CALCULATE(DISTINCTCOUNT(CLIENT_ID)); [CALCULATEDCOLUMN] = 1)

But, as it turns out, even if the aggregate total is not greater than 1, it would still count the CLIENT_ID, because in the first and the last row for example, the sales would be greater than 0.

[Greg_Deckler · Accepted solution]

Measure =

COUNTROWS(

  DISTINCT(

  SELECTCOLUMNS(

  FILTER(

    SUMMARIZE(

      'Table',

      [CLIENT_ID],

      "__Sum",SUM('Table'[LIQUID_SALES])

    ),

    [__Sum] > 1

  ),

  "__Client",[CLIENT_ID]

  )

  )

)