sum by group and count if

[LS1700]

Hi, 

I would like to have a measure that can tell me how many cusotmer have not sold a single unit in total.

The measure ( I think) should do the sum of the sales by customer and then count those who have sales=0.

Any idea?

in the below case it should be =1.

Customer	Model	Sales
A	X	1
A	Y	0
A	Z	1
B	X	1
B	Y	1
B	Z	1
C	Y	1
D	X	0

thanks

[Anonymous · Accepted solution]

I didn't try this... but it sounds kinda nice...?  🙂

Total Sales = SUM(MyTable[Sales])

Losers = CALCULATE(DISTINCTCOUNT(MyTable[Customer]), FILTER(VALUES(MyTable[Customer]), [Total Sales] = 0))

[jetboy2k]

Thanks! Completely solved my problem!

[AlanBaker]

Brilliant! Works like a charm and JUST what I was looking for....