I have a table contains the following columns in addition to many The ActivityDate is used in a slicer I need to calculate the disticntcount of Account names that have more than 1 activity subject to the selected period in ActivityDate slicer Account NameActivityDateAccount A1/1/2020Account A1/7/2020Account A1/8/2020Account A1/1/2021Account B1/1/2019Account B1/1/2020Account B1/7/2020Account C1/1/2018Account C1/1/2020Account C1/7/2020Account C1/9/2020Account C1/10/2020Account D1/1/2020 Mainly I tried the following SUMMARIZE( Activities, Activities[Account Name], "ActivitiesCount",COUNTA(KinzActivities[Account Name] )but I didn't know how to filter the resulted table according to the calculated column "ActivitiesCount"

Forum Discussion

Helper V

4 years ago

Solved

I have a table contains the following columns in addition to many

The ActivityDate is used in a slicer

I need to calculate the disticntcount of Account names that have more than 1 activity subject to the selected period in ActivityDate slicer

Mainly I tried the following

SUMMARIZE(
            Activities,
            Activities[Account Name],
            "ActivitiesCount",COUNTA(KinzActivities[Account Name]
        )

but I didn't know how to filter the resulted table according to the calculated column "ActivitiesCount"