Forum Discussion

LS1700's avatar
LS1700
Icon for Resolver I rankResolver I
9 years ago
Solved

sum 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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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))

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
jetboy2k
Icon for Helper I rankHelper I
8 years ago

Thanks! Completely solved my problem!