How one to many relationship works?

[jithinrg]

I have a dim and fact table connected via one to many relationship.

Dim table : Country with targets

Country	Target
IN	200000
UK	500000
US	1000000

Fact table: Actual transactions

Date	Country	Sales
1/2/2023	IN	4567
4/5/2023	US	56789
3/4/2022	US	43456
5/6/2021	UK	125678

Relationship : Country(dim) to Country (fact) 

Cardinality : one to many

When I dragged Country from fact and target from dim table, with Don't summarize it shows correct values. (implicit measure)

But when i created an explicit measure for Target = SUM (Country[Target]) and dragged into the same table it show total values repeated for each rows.

Default aggregation for both value columns are "Don't summarize"

So I'm confused, how that works. 

Can anyone help me to understand this is much appreciated.

Also I have a question regarding how to model dim tables with target values and connect to a fact table with a project having RLS and page level security. Please share the best practises.

[amitchandak]

@jithinrg ,Somehow I see same values

In this country, should always be used from Dim table.

Or you have use meausre like

Sumx(Summarize(Target, Target[Country], Target[Target]), [Target])