Use the Calculate formula by a Distinct Count from the Sum of another Column in the Table

[Amos1992]

So I want to use the calculate function but I'm really struggling with getting it to work in this instance. From the table below, I want to identify the number unique of customers whose sum of quantities of a certain product come to zero.

From the table below as an example, the DAX formula should come back with 3 customers because they didn't buy a particular product from Range 2. Hope that makes sense, all help much appreciated.

[MFelix · Accepted solution]

Hi @Amos1992 ,

Try the following measure:

Measure = 
VAR Total_Quantity =
    SUMMARIZE (
        'Table',
        'Table'[Customer Type],
        'Table'[Product],
        'Table'[Product Range],
        "Quantity Total", SUM ( 'Table'[Quantity] )
    )
var ttt = SUM('Table'[Quantity])
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Customer Type] ),
        FILTER ( Total_Quantity, [Quantity Total] = 0 )
    )