topic Re: Show only 1 of a number of duplicate values in DAX Commands and Tips

Show only 1 of a number of duplicate values

Tob_P — Wed, 03 Aug 2022 10:11:12 GMT

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

Re: Show only 1 of a number of duplicate values

stevedep — Wed, 03 Aug 2022 10:22:43 GMT

Hi,

In Power Query you can remove duplicates.

Re: Show only 1 of a number of duplicate values

Tob_P — Wed, 03 Aug 2022 10:26:50 GMT

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.

Re: Show only 1 of a number of duplicate values

stevedep — Wed, 03 Aug 2022 11:32:09 GMT

Hi,

What is the unique identifier of the record?

Re: Show only 1 of a number of duplicate values

Tob_P — Wed, 03 Aug 2022 11:36:58 GMT

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

Re: Show only 1 of a number of duplicate values

stevedep — Wed, 03 Aug 2022 13:19:26 GMT

Something with Ranking, and only showing the first value?

Re: Show only 1 of a number of duplicate values

Tob_P — Mon, 08 Aug 2022 08:20:42 GMT

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.

Re: Show only 1 of a number of duplicate values

Anonymous — Fri, 09 Jun 2023 19:32:12 GMT

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

Re: Show only 1 of a number of duplicate values

Tob_P — Mon, 12 Jun 2023 07:21:19 GMT

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.