RelatedTable

[Anonymous]

Good day,

I need a way to view the Users that are in the UserUsers table that are not in the UserNodes table.

I've tried  using relatedtable, but it returns the users that are in both of the tables - thus not solving the issue, but could help calculate how many users are not in the UserNodes table, but as mentioned, I need to put the user details in a table.

Please can someone assist?

Regards,

[Mariusz · Accepted solution]

Hi @Anonymous 

One way of doing it would br creating a table with DAX expression like below.

Table = 
EXCEPT(
    VALUES( UserUsers[UserID] ),
    VALUES( UserNodes[UserID] )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.