Forum Discussion

PriyaJha's avatar
PriyaJha
Icon for Helper I rankHelper I
5 years ago
Solved

DAX for average with multiple criteria

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 crit...
  • NandanHegde's avatar
    NandanHegde
    5 years ago

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

NandanHegde's avatar
NandanHegde
Icon for Super User rankSuper User
5 years ago

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