Forum Discussion
Mapping issue-looking to fix thorugh dax expression
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
2 Replies
- Greg_Deckler
Community Champion
Anonymous You are almost certainly missing a relationship between your two tables.
- v-easonf-msft
Community Support
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
