Problem: We were combining data from 2 source systems and transforming directly within Power BI and as a result, need to filter Contract Manager which can come from either system
Approach: You can create derived column and use CONCATENATE DAX formula to get the value, DAX example as below and then you can use Text Filter – so it can filter in either column
DerivedFiledName = CONCATENATE( ‘DataSource 1′[DS1FieldName] ,’DataSource2′[ DS2FieldName])
