I am new to Power BI and in need of help.
I have two tables. User and Report
1 - TestUser - ['A'] - ['E','F']
2 - UserOne - ['B','C'] - ['D']
A,B,C - product names
D,E,F - Order numbers
1 - Completed - A - E
2 - InProgress - B - F
3 - Completed - C - D
4 - Completed - A - D
So, when I use the USERNAME() expression evaluated to the logged-in user, I need to see the reports table filtered based on product array and order_number array of the user. So that means, all the rows with products 'A' OR order_numbers 'E','F' should return (rows 1,2,4 in this case for TestUser and 2,3,4 for UserOne).
What would be the DAX expression to achieve this?
Thanks in Advance!!!