Creating measure that in itself its fileting data

[mpesec]

Hi everyone.
I have a short question.
I am trying to create measure in Power BI that is disregarding specific valies in the coloumn.
For excample.

I am trying to calculate average sales ( I would take Sales Column) but I would not like to get certain product inside ( column Product- but would not like to see "Product A" but all the other products I would like to count in the average sales.

Thank you in advance

[amitchandak · Accepted solution]

@mpesec , Try a measure like

Calculate(Average(Table[Sales]), filter(Table, Table[Product] <> "Product A"))