Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

@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
Super User
Super User

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors