DAX for average with multiple criteria

[PriyaJha]

I have 4 columns in table called Month, Object, status, value. I want the MEASURE average of value only for specific status and for specific year so how i can write the average DAX with multiple criteria.

In excel i can easily write as averageifs(value, Month=Jan, status="Sold").

I WANT THE MEASURE ONLY.

Please suggest. i tried every and did not get success to add multiple criteria's.

[NandanHegde · Accepted solution]

Hey,
You can use the below command for the output:

average_ =
CALCULATE(
AVERAGE(your_table_name[value]),
FILTER(
ALL(your_table_name),
your_table_name[month] = Jan
&& your_table_name[status] = "sold"
)
)