Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Assistance required with formulating Measures

HI Guys

 

so i have a data set and within it there are 2 columns One of them is quanity and the other is category type. 

I want to count the total quantity, without a certain categroy name being accounted for.

 

i.e. count all of the quanitys except for when the category name is 'Drops'.

 

Can you help?

 

 

Need Help
  • Stachu's avatar
    Stachu
    7 years ago

    you will need to adjust the table and column names

    CALCULATE(SUM(Table[Quantity]), Table[Category]<> "Drops")

1 Reply

  • Stachu's avatar
    Stachu
    Community Champion
    7 years ago

    you will need to adjust the table and column names

    CALCULATE(SUM(Table[Quantity]), Table[Category]<> "Drops")