https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-average-with-multiple-criteria/m-p/1641419#M33334 <P>Hey,<BR />You can use the below command for the output:<BR /><BR />average_ =<BR />CALCULATE(<BR />AVERAGE(your_table_name[value]),<BR />FILTER(<BR />ALL(your_table_name),<BR />your_table_name[month] = Jan<BR />&amp;&amp; your_table_name[status] = "sold"<BR />)<BR />)<BR /><BR /></P> Wed, 03 Feb 2021 10:27:11 GMT NandanHegde 2021-02-03T10:27:11Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-average-with-multiple-criteria/m-p/1641413#M33333 <P>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.</P><P>In excel i can easily write as averageifs(value, Month=Jan, status="Sold").</P><P>I WANT THE MEASURE ONLY.</P><P>Please suggest. i tried every and did not get success to add multiple criteria's.</P> Wed, 03 Feb 2021 10:26:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-average-with-multiple-criteria/m-p/1641413#M33333 PriyaJha 2021-02-03T10:26:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-average-with-multiple-criteria/m-p/1641419#M33334 <P>Hey,<BR />You can use the below command for the output:<BR /><BR />average_ =<BR />CALCULATE(<BR />AVERAGE(your_table_name[value]),<BR />FILTER(<BR />ALL(your_table_name),<BR />your_table_name[month] = Jan<BR />&amp;&amp; your_table_name[status] = "sold"<BR />)<BR />)<BR /><BR /></P> Wed, 03 Feb 2021 10:27:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-average-with-multiple-criteria/m-p/1641419#M33334 NandanHegde 2021-02-03T10:27:11Z