Help Removing Duplicate Values But Maintaining all Rows

[ace12]

Hi, I have an extremely large data set. I am looking for a way to remove duplicate values for any given entry. I would like to maintain all the rows however. Is it possible to only show the first occurence based on a specific entry and then just make the duplicate rows blank. Here is an idea of what I'd like my power BI table to look like:

Is this possible? I have over 40 columns in my table and I need all rows. 

[audreygerred · Accepted solution]

Depending on what the desired output is, you can create a solution through a DAX measure. For example, if in your report you want to have the Total Amount (your last column) sum the unique values from Total Amount (your second column), the duplicates are fine. You would create a measure that sums the min/max/average using an iterator function of SUMX.

For example, I entered the following data which matches your first two columns: 

Now, assuming you want a total of the unique values of total amount per entry you would do the following DAX measure:

Amount Total = SUMX(SUMMARIZE('Table','Table'[Entry],"MinTotalAmount",MIN('Table'[Total Amount])),[MinTotalAmount])

Then you can create a visual that shows the unique amount for each entry and what they all sum up to: 

[ace12]

Genius!

[Daniel29195]

@ace12 

just one question. why do you need to do such a thing ? 

i would rather do the following : 
in power query, use the groupby feature : ( you can find it under  transform -->  groupby ) 

output : 

new table : 

this way, you will have the count of entries which is 3 per each entry  and sum =  500

groupby configuration 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[ace12]

The reason I need to do this is because it is the only column in my table that assigns a total value. So when I go to add this up it adds the total multiple times (or however many entry lines there are).

The rest of the values in my table are all allocated correctly per line. So when I go to sum them all is good.

If I group I will lose all the individual line item information I need.