Forum Discussion
Creating measure that in itself its fileting data
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
Anonymous , Try a measure like
Calculate(Average(Table[Sales]), filter(Table, Table[Product] <> "Product A"))
1 Reply
- amitchandak
Super User
Anonymous , Try a measure like
Calculate(Average(Table[Sales]), filter(Table, Table[Product] <> "Product A"))