Duplicate rows on Table Visual

[skaranth10]

Hi,

I am facing a small problem here in trying to compile a report. It seems quite simple, but I am just not able to get the desired result.

I have two tables - OrserUserFields & Orders, which are joined through OrderId on a Many-to-One relationship. 

This is what the OrderUserFields table looks like. The OrderIds are repeated for the different LabelPrimarys (It doesn't seem to be repeated on this screenshot, but it actually is.). 

I have pivoted this table on LabelPrimary with another field called Values, and chose 'No Aggregation' in the advanced options. 

This is what the table looks like after pivoting - 

And here's what my report currently looks like - 

My requirement is to have just one row per OrderID and have the respective values for #Frozen, #Ambient, #PKU, etc. I am currently getting duplicate values on my report, as seen on the screenshot above. What can I do to fix this?

Any help would be appreciated. 

Regards,

Sanjay

[Anonymous]

@skaranth10 ,

Is it showing the duplicate values in Data Model as well?

And did you removed duplicate rows in Power Query if not required ?

[skaranth10]

Hi @Anonymous , Regarding the duplicates, the OrderUserFields table has multiple rows with the same OrderId, but deffierent value for each of the columns - #pku, #frozen, etc. 

I haven't touched anything on the Query Editor.  The only thing I have done to the data source is that I have pivoted the PrimaryLabel column on Values (Non-aggregated).  

[V-lianl-msft]

Hi @skaranth10 ,

Try use the orderid in orders table.

Without a sample pbix may not know the exact issue.See if you could share the sample pbix via cloud service like onedrive for business.

Please remove any sensitive data before uploading

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[skaranth10]

Hi @V-lianl-msft ,

I have the pbix file ready, but am not sure how I can attach it here. Any way I share it here?

I am not sure how I can share it through Onedrive for business either. 

Regards,

Sanjay

[skaranth10]

Hi @V-lianl-msft ,

I did use the OrderID from the Orders table. It still creates the duplicates for # of Ambient, # of frozen, # of Pkus, etc that I pull into the visual. A duplicate is created for each one of them on the table. 

I will work on hiding sensitive info and share the pbix file here in a bit. 

Thank you! 

Regards,

Sanjay