I am looking for something that can be either quite easy or extremely difficult.
I have a table like the following one where different lines may have the same ID and same or different values in a second column. I need to create a new table (by summarising the original one) like this:
Correct me If I am wrong but it appears to me that you simply want all Home and Complementary products columns to be treated as one. If so, you may try creating a calculated column in DAX using this formula
'TableName'[Department] = "Home"
|| 'TableName'[Department] = "Complementary products",
"Home and Complementary",
Then use this newly calculated column in the table visual instead of the old one.
Did I answer your question? Mark my post as a solution! "Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand." www.linkedin.com/in/danebelarminocpa