Measure adds rows to table that don't exist

[MrNew]

Hi

I've trawled the forums for this and there's a few questions that are similar but the answers seem to give very specific solutions / measures that don't explain what's happening or the question is left unanswered. 

I have Table 1 and Table 2, with a 1:1 relationship between document ID:

If I create a table visual with data from Table 1, the result is as expected

Same with Table 2

If I combine the two tables in a visual, with Document ID, poststatus and dispatch_status, result is still all good:

Now where I run into issues is adding a measure. My measure is literally only adding a number "=1"  like so:

If I add it to table 3, the result is as follows:

My Expected result would be 

document_id	dispatch_status	poststatus	Measure
1	deleted	D	1
2	posted	P	1

instead, PowerBI adds 3 extra rows for each documentID for whatever reason (please someone elighten me)

This is sample data, but i'm trying to create measures in the live file and the above is really throwing me off. 

Thanks in advance 

[v-xiaotang]

Hi  @MrNew 

Thanks for reaching out to us.

This seems to be some kind of typical problem: when the relationship is not clear, the measure will be calculated for each row. please share the sample file, we'll troubleshoot it.

Best Regards,

Community Support Team _Tang

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

[MrNew]

@amitchandak i've changed it to one to many, treating one table as a master. No change in table 3:

Table 3:

[MrNew]

So nobody knows why this happens? 

[MrNew]

@amitchandak thanks for the response. How do I add a master table with one to many directional join, if there is only ever one documentID for each row in both tables? 

[amitchandak]

@MrNew , Treat one of them as master or better merge them in power query 

 https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[amitchandak]

@MrNew , Prefer to make it one to many single directional join. One of the table should act as master