Measure Zero not equal to Zero

Anonymous 
You have a basic logic/concept mistake.

You need to sum the sales by ID.
Something like 

Column Non Zero Product Sales =
VAR TOTAL_SALES_PER_PRODUCTID =
    CALCULATE (
        SUM ( Sheet1[sales] ),
        FILTER (
            Sheet1,
            Sheet1[productid]
                = EARLIER ( Sheet1[productid] )
        )
    )
RETURN
    IF (
        TOTAL_SALES_PER_PRODUCTID = 0,
        0,
        TOTAL_SALES_PER_PRODUCTID
    )

And then work according to the results in that column.

It will give you 0 for ID 4,5.
Then Count

Non Zero Product Sales =
CALCULATE (
    DISTINCTCOUNT ( Sheet1[productid] ),
    FILTER (
        Sheet1,
        Sheet1[Column Non Zero Product Sales] <> 0
    )
)

Thanks!
A