Values are duplicated in table chart or matrix chart

[Anonymous]

I have two tables 

Table A

ID    Site           

1     London

2     France 

3     Dubai

1     London 

1     London

Table B

ID Amount

1  100

2  200

3 300

1  200

1  200

I want to see the SUM(Amount) for London, there is no relation b/w Table A and B 

When I create a power BI viz, values are being duplicated for example,

Site        SUM(Total Amt)

London  500

London  500

London 500 

Value is being shown multiple times in table chart, i also tried matrix but of no use. Pls help.

[Anonymous]

@Anonymous 

What's the point of keeping dups in a dimension table? That goes against all the common wisdom about dimensional modeling. Please do not make your life harder than it should be 🙂 Just remove the dups from the dimension table (Table A) and do not ever slice by fields directly placed in a fact table. Just follow Best Practices and you'll be safe. Here's something about the celebrated star-schema design (the only one that always WORKS correctly in PBI and should not ever be deviated from): Understand star schema and the importance for Power BI - Power BI | Microsoft Docs

[amitchandak]

@Anonymous , Not sure what else is there in table A.

I would suggest to create a new Site table

Site = summarize(TableA, Table[ID], Table[City])

Join with table B and use.

Try to be in Star Schema

https://www.youtube.com/watch?v=vZndrBBPiQc&feature=youtu.be