Filter multiple columns in a Table using OR condition
I want to be able to search and filter using a Value in multiple columns in a Table.
For example I have an Employee table with columns: FirstName, LastName and EmpID.
I want to filter this table and display Rows that contain the value "Sam" either in FirstName or LastName column.
The DAX query in Desktop could be: = if (([FirstName]="Sam" OR [LastName]="Sam"), [EmpID], null)
This cannot be done from Power BI Service, as we cannot change the value in DAX formula. I cannot filter the table using different values.