Forum Discussion
LS1700
Resolver I
Resolver Isum by group and count if
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 t...
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))
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))
Brilliant! Works like a charm and JUST what I was looking for....