Use 3 (or) filters on on table

[CJaber]

Hi, 

I have a table that I need it to show specific values based on 3 different filters. I want to show only the data when [used price]=0 (This is a calculated column that uses a math formula from 3 different columns) or when [Cost Margin] <=15% or when [Shipped Cost Margin]<= 15% 

I tried this formula but had no luck. I tried it in both the Measure and the Calculated column 

Filter = FILTER(Merge1, Merge1[UsePrice]=0|| Merge1[Shipped Cost Margin]<=0.15||Merge1[Cost Margin]<= 0.15)

I am not aware of a way to use the Filters Filed to show all three values 

Please help 

[CJaber]

That worked. Thank you 

[tamerj1]

Hi @CJaber 

nothing wrong with the FILTER statement. It is just you are returning a table inside a measure which is not acceptable. What are you trying to achieve? If you want to use it as a filter for a certain visual you can place following measure in the filter pane of that visual, select "is not blank" and apply the filter 

Filter = COUNTROWS ( FILTER(Merge1, Merge1[UsePrice]=0|| Merge1[Shipped Cost Margin]<=0.15||Merge1[Cost Margin]<= 0.15) )