Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Show only 1 of a number of duplicate values



I'm looking to suppress these duplicate values. I need to be able to see all the Quote No's, their corresponding branch, contacts, customer & project names but just see the value on one row. To further add to this, and this may help..


Quote No/Type/Date/Contact/Project Name - Table 1

Branch - Table 2

Customer Name - Table 3

Value - Table 4


Thanks in advance





Regular Visitor

Hi @Tob_P I'm having a similar problem with my data. Did you ever solve this issue and can provide some insight?

I think I ended up dropping what I needed in this example, but if I were to tackle it now I probably would have used the RELATED function in Table 4, to bring in the Quote No (I'm pretty sure my existing relationship between Tables 1 & 4 would have required this), and create a calculated column.

Helper IV
Helper IV

Wondering whether anyone has any insight on this. Not an issue with my relationships.


Have tried a couple of things - SUMMARIZE function and creating a calculated column to CONCATENATE Project Name & Quote Number to create a unique ID and FILTER on that but with no success.


Trawling through the forum here but can't find a case study that fits the profile of this queston.


Thanks again in advance.

Helper IV
Helper IV

Hi @stevedep Unfortunately that's not an option for me as I believe that it would wreck the outputs in the rest of the report.

In this case I would want to go with the Project Name - it will only ever have one value in it but will have multiple quotes

Something with Ranking, and only showing the first value?

Memorable Member
Memorable Member



In Power Query you can remove duplicates. 



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors