Forum Discussion

skaranth10's avatar
skaranth10
Helper I
5 years ago

Duplicate rows on Table Visual

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

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      skaranth10
      Helper I
      5 years ago

      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's avatar
        V-lianl-msft
        Community Support
        5 years ago

        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.