Report Level Filter OR Condition?

[Anonymous]

I have a product table that has 4 columns: ID, Product Name, Sale, Cost (Sale and Cost are calculated columns). I want to apply a report level filter to filter out a product that either has Sale > 0 or Cost > 0. Is it possible to apply OR condition on report level filter? I would really appreciate for any feedbacks or solutions. 

[Greg_Deckler · Accepted solution]

I think that you would create a measure that would implement your OR condition and return back a 1 or a 0 based upon that information and then filter on that measure?

[Anonymous]

 Hi Greg, do you have any example or link to reference?

Thank you!

Max