Lookup Distinct Admin Names to a Blank table

Hi Newbie22 ,

try this

Table = DISTINCT(
                 UNION(
                    SELECTCOLUMNS('Case',"Name",'Case'[Admin Name]),
                    SELECTCOLUMNS('Task',"Name",'Task'[Admin Name])
                 )
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello 

Try to crete this table : 

Blank table = 
var _temp = 
    UNION(
        SUMMARIZE('Case','Case'[Admin Name]),
        SUMMARIZE(Task,Task[Admin Name])
    )

return 
DISTINCT(_temp)

Best regards

Bruno Costa | Continued Contributor

Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

Take a look at the blog: PBI Portugal