The column cannot be pushed to the remote data source and cannot be used

Hello, 

I created a table and gained a list of user_id of internal users. Then I tried to use this list to create a new column in my main table by matching the user_id with the list of user_id of internal users. However, I got the error message that "The column cannot be pushed to the remote data source and cannot be used in this scenario". Can some one help? Thank you so much in advance! 

The DAX code of the table expression which gained  the list of user_id of internal users: 

internal user = SELECTCOLUMNS (
    SUMMARIZE (
        CALCULATETABLE (
            'Main table',
            'Another table'[Type] = "Internal"
        ),
        'Main table'[user_id]
    ),
    "user_id", 'Main table'[user_id]
)

 I tried to create a new column in my main table by using the values from tne internal user table but got the error messages mentioned above: 

User Type =
    SWITCH(
        TRUE(),
       CONTAINS('internal user',
       'internal user'[user_id],
       'Main Table'[user_Id]),
       "Internal users","Other Users"
        )