SUM row with double if / Filter

[Anonymous]

hi,
can you help me.

i want to sum Total Budget with 2 filter. first filter is find project in 2017 and status of project is Close.

already try with a data dax in power bi but still got error.

a= SUMX('Total Project';

IF('Total Project'[Tahun]=2017;

IF('Total Project'[Status]="Close";

SUM('Total Project'[Total Budget]))))

for the data:

thank you

[v-lili6-msft]

HI @Anonymous 

First, Add a CALCULATE in your formula or use the formula as vimal_parmar said.

a = SUMX('Total Project';

IF('Total Project'[Tahun]=2017;

IF('Total Project'[Status]="Closed";

CALCULATE(SUM('Total Project'[Total Budget])))))

Second, please notice that it is "Closed" not "Close"

Regards,

Lin

[Anonymous]

hi @v-lili6-msft ,

ah thank you
sorry my bad heheheh
but it's works too!
thank you so much!

[Anonymous]

additional,

it's work without error

but there's is no result
the result is blank

[Anonymous · Accepted solution]

@Anonymous Please try below

Measure = CALCULATE(SUM('Total Project'[Total Budget]),'Total Project'[Tahun]=2017,'Total Project'[Status]="Close")

[Anonymous]

hi vimal!

ah thank you for your code and it's simple too!
it's works

thank you!