Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Datagulf
Responsive Resident
Responsive Resident

Adding a clause in the following formula

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?

1 ACCEPTED SOLUTION

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

View solution in original post

2 REPLIES 2
Samarth_18
Community Champion
Community Champion

Hi @Datagulf ,

 

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

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.