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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.