Adding a clause in the following formula

[Anonymous]

I have a formula that I got which was written by somebody else.

Top 100K accounts = SUMX ( FILTER ( GROUPBY ( 'Dataset', 'Dataset'[CompanyName], "_1", SUMX ( CURRENTGROUP (), 'Dataset'[Amount] ) ), [_1] >= 100000 ), [_1] )

 I want to add a clause and filter the data by using a categorical column. Like country = United Kingdom. How would I add this in the formula above?

[Samarth_18]

Hi @Anonymous ,

Please try this:-

Top 100K accounts =
SUMX (
    FILTER (
        GROUPBY (
            'Dataset',
            'Dataset'[CompanyName],
            'Dataset'[country],
            "_1", SUMX ( CURRENTGROUP (), 'Dataset'[Amount] )
        ),
        [_1] >= 100000
            && [country] = "United Kingdom"
    ),
    [_1]
)

Thanks,

Samarth

[Anonymous · Accepted solution]

Hello @Samarth_18 , it does not work. I have opted for page filters for now. Thanks.