Hi!
I have a dataset with two columns, "ID" and "Category", where one item can be related to multiple categories, so item ID1 occurs twice, with Category1 and Category2.
I wanted to manually filter out the duplicate value, so I created a calculated dimension of {ID}+"-"+{Category} to see the unique value and filter out one of them, but even if I apply the filter, I can still see that row in my dataset, i.e. the filter doesn't work.
Any ideas on why that is? I've done this before with other datasets and never had this problem before.