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

[Yiyi_1989]

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"
        )

[AnthonyGenovese]

Personally, I would do all of this in Power Query. Create a new query for what you are looking for, then join that query to get your new column.

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!