distinct count of multiple columns across tables

[rhl94]

Hi,

I want to do a unique count across multiple columns - exactly like this case: https://community.powerbi.com/t5/Desktop/distinct-count-of-multiple-columns/td-p/433060

However, the two columns that I want to use, are not in the same table, so the answer is not sufficient in my case. The two tables are however related (they both have a matching PK/FK)

Table 1:

Column A: ID

Column B: First Name

Table 2:

Column A: ID

Column B: Last Name

I want a distinct count of the two column B. As the data is a live connection, I can't use Power Query.

[Zubair_Muhammad · Accepted solution]

@rhl94 

Try following

Measure =
COUNTROWS (
    DISTINCT (
        UNION ( VALUES ( Table1[First Name] ), VALUES ( Table2[Last Name] ) )
    )
)