cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
achillies21
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.

 

2 REPLIES 2
daxer
Solution Sage
Solution Sage

@achillies21 

 

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
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

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



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

Announcements
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!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors