Need help in writing the DAX

[Etsu0411]

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")

[v-jianboli-msft · Accepted solution]

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.

[Greg_Deckler]

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