How to select only the unique Customer ID on the dataset level?

[sagmukhe]

@Biswajit_1993 - Okay Got it. Basically you are looking for duplicate removal options at the dataset operations. I don’t think something of that sort is currently available. You need to do it before bringing the data into QuickSight in case you would like that to be available at the dataset level itself that way. Here’s a relevant post regarding that

Remove duplicate rows from dataset

Hello @egobbo . You can also create calculated fields at the dataset level and then create a filter at the dataset level as well. This way you can filter the data directly there and make sure that all the analyses that use it received the filtered data. However remember that it is the best practice to work with already clean and massaged datasets to avoid overloading the BI layer with calculations and filters so your visuals can render blazing fast. I would recommend to create a data pipelin…

Hope this helps!