https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/sumif/m-p/824175#M5721 <P>hi</P><P>Hi<BR />How do I make calculations with dax like counting in the excel sumif formula table that I have:</P><P>Year Value<BR />2018 100<BR />2019 300<BR />2018 50<BR />2019 100<BR />Sumif 2018 = 150</P><P>thank you</P> Tue, 22 Oct 2019 05:04:21 GMT Anonymous 2019-10-22T05:04:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/sumif/m-p/824175#M5721 <P>hi</P><P>Hi<BR />How do I make calculations with dax like counting in the excel sumif formula table that I have:</P><P>Year Value<BR />2018 100<BR />2019 300<BR />2018 50<BR />2019 100<BR />Sumif 2018 = 150</P><P>thank you</P> Tue, 22 Oct 2019 05:04:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/sumif/m-p/824175#M5721 Anonymous 2019-10-22T05:04:21Z