cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Need help in writing the DAX

Hi Mates,

Can you please help me in decoding the below excel formulae and to write the same as DAX in Power BI

=SUMIFS('Sheet1'!\$F:\$F, 'Sheet1'!\$A:\$A, B\$2, 'Sheet1'!\$B:\$B, \$A4, 'Sheet1'!\$E:\$E, "Private")

1 ACCEPTED SOLUTION
Community Support

Hi @Etsu0411 ,

Approve with @Greg_Deckler . Besides, you can use Calculate(Sum(...),Filter(...)) too.

Based on your description, I have created a simple sample:

After connect to Power BI:

Here is the DAX:

``````Measure = SUMX(FILTER('Table',[Column A]="B"&&[Column B]="A"&&[Column E]="Private"),[Column F])

Measure 2 = CALCULATE(SUM('Table'[Column F]),FILTER('Table',[Column A]="B"&&[Column B]="A"&&[Column E]="Private"))``````

Fianl output:

For more details, please refer to:

CALCULATE function (DAX) - DAX | Microsoft Learn

SUMX function (DAX) - DAX | Microsoft Learn

FILTER function (DAX) - DAX | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Community Support

Hi @Etsu0411 ,

Approve with @Greg_Deckler . Besides, you can use Calculate(Sum(...),Filter(...)) too.

Based on your description, I have created a simple sample:

After connect to Power BI:

Here is the DAX:

``````Measure = SUMX(FILTER('Table',[Column A]="B"&&[Column B]="A"&&[Column E]="Private"),[Column F])

Measure 2 = CALCULATE(SUM('Table'[Column F]),FILTER('Table',[Column A]="B"&&[Column B]="A"&&[Column E]="Private"))``````

Fianl output:

For more details, please refer to:

CALCULATE function (DAX) - DAX | Microsoft Learn

SUMX function (DAX) - DAX | Microsoft Learn

FILTER function (DAX) - DAX | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User

@Etsu0411 You can use SUMX(FILTER(...), ...)

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors