Mapping issue-looking to fix thorugh dax expression

[Anonymous]

Hi Team,

I'm having two reports as per below,

Out put of report 1: Note(Country details from Table 2 and Sales numbers from Table 2)

Country, Sales

UK,1000

US,2000

Output of report 2: Note(Country details from Table 1 and Sales numbers from Table 2)

Country,Sales

UK,3000

US,3000

Probelm: I need to pull Country details from Table 1 and Sales numbers from 2 ,but expected results are like below,

Country,Sales

UK,1000

US,2000

kindly help.

Thanka in advance

[v-easonf-msft]

Hi,  @Anonymous 

You'd better need to recheck the relationship between the tables, including cross filter direction (single, both), cardinality (one-to-one, many-to-one...)

Best Regards,
Community Support Team _ Eason

[Greg_Deckler]

@Anonymous You are almost certainly missing a relationship between your two tables.