Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Values are duplicated in table chart or matrix chart

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.


Solution Sage
Solution Sage



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

Super User IV
Super User IV

@achillies21 , 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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors