Forum Discussion
Solved
Removing Duplicate Rows in Some Situations
I'm a complete BI newbie. I've got a table imported. I'm doing some basic analytics that are proving to be more complicated than I thought! I have a table of people. I have a handful of columns ...
Hi,
This DAX formula works
=SUMX(SUMMARIZE(VALUES(Table1[Address]),[Address],"ABCD",MIN(Table1[Count])),[ABCD])
Hope this helps.
One way is to use the GROUPBY function. I named your columns Individual, Address, Category, and Number, in that order. This will create a new table that gets rid of the duplicates. In the Modeling Tab, select New Table, then use this formula.
By Category =
GROUPBY(
People,
People[Category],
People[Address],
People[Number]
)