Forum Discussion
Remove Duplicates using DAX
Hi Team, I am developing a report where i need to use table visual and have to display the columns as shown below. Col1 Col2 Col3 Test1 .abc .123 .abc .234 ...
Hi SushmaReddy ,
Assuming that you want to keep only the first Col3 row the min data by Col1 and Col2, create a calc column using the formula below (change the table and column names accordingly):
=
CALCULATE ( MIN ( [Col3] ), ALLEXCEPT ( Table1, Table1[Col1], Table1[Col2] ) ) = Table1[Col3]
This will return 1/0. Use this column in the filter pane. Set the value to 1.
Or you can use this in a measure
=
CALCULATE ( [Original Measure], FILTER ( Table1, Table1[MinValue] = 1 ) )