Pull data from one table to another without relationship

Hi Anonymous 

Ensure that the relationship between the two tables is properly established.

Try this:

Create a column.

Unique Conversation ID Count 1 = 
CALCULATE(
    DISTINCTCOUNT('Table 1'[Conversation ID]),
    ALLEXCEPT('Table 1', 'Table 1'[Store No])
    
)

or

Unique Conversation ID Count 2 = 
CALCULATE(
    DISTINCTCOUNT('Table 1'[Conversation ID]),
    FILTER(
        ALL('Table 1'),
        'Table 1'[Store No] = EARLIER('Table 1'[Store No])
    )
)

Here is the result.

Regards,

Nono Chen

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