Filtering specific text from total count of another column

[SerDontos]

Hello,

I have two columns, one of which contains the names of products and the other the count for how many of those products were sold. I wish to remove a specific product (ACCESSORIES) from the total count of the second column if possible.  Here are the two columns and the measure I used to get that total.  Any help will be greatly appreciated.

[az38]

Hi @SerDontos 

if @Chthonian idea will not help you, maybe you can try smth like

TotalMeasure = CALCULATE(COUNTROWS('Back End'),
ALLEXCEPT('Back End', 'Back End'[Aftermarket Desc. 2]),
'Back End'[Aftermarket Desc. 2] <> "ACCESSORIES"
)

 at first glance of your example you want to calculate count grouped by products

[Chthonian]

Hi @SerDontos 

Just a rough idea on how to get what you need

TOTAL AFTERMARKET = CALCULATE(
   COUNTROWS('products'),
   'products'['Aftermarket Desc 2'] <> "ACCESSORIES"
)