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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ckchhabra
New Member

Slicer showing duplicates

Hello All,

 

I have a fact table 'Table1' in which I have buyer_name column that has names of buyers (all my tables are in direct query). This table has duplicate values of buyers. So when I use this field in slicer, I see duplicates in it. Then I create a new table using below dax which removes the duplicates-

 

ckchhabra_0-1666968948429.png

 

Table 2 = SUMMARIZE('Table1','Table1'[buyer_name])

 

TABLE 2 is now an import query.

 

Then I create a relationship between them but I am getting many to many relationships which should not be possible as table 2 has distinct values. I dont understand why! Though I can see distinct values in slicer using table 2 buyer name. Should I use it ayways?

 

Method 2 that I tried -

I also tried referencing table 1 to create table 2  (this case table 2 is direct query) and then joined them using one to many relationship (it was showing nw in pbi) but however, when I use the new column buyer_name in slicer, baam..I can STILL SEE DUPLICATES, even though table 2 only has distinct values. I just dont knw what is happening! Is is due to some direct query bug?

Please help

3 REPLIES 3
ckchhabra
New Member

So, I just found that power bi is duplicating one of the buyer names when i create a calculated table table 2 using summarize dax function. I have tried groupby, value, distinct, but still it is duplicatng one of the buyer name. I dont know why. 

but when I create another table Table 3 and use group by with Table 2. Then it gives me the right result.

However, when i export the duplicated Table 2 to excel, i cannot see that duplicate buyer name. It comes only one time.

I dont know whats happening here.

amitchandak
Super User
Super User

@ckchhabra , Please use clean and trim in power query and see if that can solve the issue

 

Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4

Hi @amitchandak 

 

I tried trim using dax for calculated table Table 2, but it is still detecting many to many relationship. 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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