Forum Discussion

AnjanaHaridasan's avatar
AnjanaHaridasan
New Member
3 years ago
Solved

OR two fields in power BI

I am in a Business Object report to Power BI conversion. Basically I am drag and drop the fields from the Dataset created and so all the fields in the SQL 'WHERE '  clause are converted to filter fields/slicer visuals in Power BI. There is a criteria in the BO SQL that c.story_ty in (1,2)

AND

(

a.fc_Name like '%YYYY%'

OR

b.dep_name like '%YYYY%'

)

My question here is how do I implement the OR logic in Power BI slicer/filter ? I know that filters are  AND logic but these two fileds are from 2 tables 

1 Reply