Forum Discussion
Filter table based on another filtered table
Hi, I have two tables: Table1: User ID [email protected] 1 [email protected] 2 [email protected] 3 [email protected] 4 Table2: Locations Enabl...
Thank you for help
Yes, I did so in other reports with small tables
But in this case Table1 contains 40 users and Table2 contains 2 millions of rows. After relationship I have about 30 millions rows
That's why I created a function to concatenate users for every row of Table2
So how can I do it in DAX?
Or what is the correct approach in this scenario?
Phil_Seamark
Microsoft Employee
Microsoft EmployeeDAX is optimised for column-based calculations so it prefers you to have data like this in rows, rather than concatenated.