Forum Discussion
How to use or function with filters
I was able to solve it like this. I created two separate measures, one with filters by customer numbers and another one with products filtered. Then I created a third measure that sum boths and that's it.
Super UserHi Petegdl23 ,
FILTER function returns a table and OR function is expecting a boolean result as the input. That's the reason you are getting an error that 'filter is used in a True /False expession.'
Please try this code and see if it works:
I have used RELATED function to get the corresponding value of the Customer_Number.
Channel Customer = CALCULATE (
SUM ( 'Finance fact_Revenue_Lines'[Total_Amount] ),
FILTER (
'Finance dim_GL_Item',
CONTAINSSTRING ( 'Finance dim_GL_Item'[Product_Level_2], "Product Name" )
|| CONTAINSSTRING ( RELATED ( 'All dim_Customer'[Customer_Number] ), "4066-01" )
)
)
Upvote and accept as a solution if it helps!
I was able to solve it like this. I created two separate measures, one with filters by customer numbers and another one with products filtered. Then I created a third measure that sum boths and that's it.