https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Measure-to-calculate-total-sales-on-specific-year/m-p/1533188#M30094 <P>Hi, first off apologies because i am a complete noob with DAX (slowly learning though).&nbsp;</P><P>&nbsp;</P><P>I am trying to write a mesure that calculates the net fee where academic year = 2021. Something similar to a SUMIF in excel. The below script im trying to use however is returning blank. Any help much appreciated.&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>AcadmeicComp = CALCULATE([NetValue],Finance_Sales[AcademicYear]=2021)</SPAN></DIV></DIV> Fri, 04 Dec 2020 14:18:42 GMT adam_mac 2020-12-04T14:18:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Measure-to-calculate-total-sales-on-specific-year/m-p/1533188#M30094 <P>Hi, first off apologies because i am a complete noob with DAX (slowly learning though).&nbsp;</P><P>&nbsp;</P><P>I am trying to write a mesure that calculates the net fee where academic year = 2021. Something similar to a SUMIF in excel. The below script im trying to use however is returning blank. Any help much appreciated.&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>AcadmeicComp = CALCULATE([NetValue],Finance_Sales[AcademicYear]=2021)</SPAN></DIV></DIV> Fri, 04 Dec 2020 14:18:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Measure-to-calculate-total-sales-on-specific-year/m-p/1533188#M30094 adam_mac 2020-12-04T14:18:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Measure-to-calculate-total-sales-on-specific-year/m-p/1533494#M30107 <P>There's not enough info here to help you.&nbsp; We need to see some data, the model/relationships and a definition of [NetValue] at the least.</P> Fri, 04 Dec 2020 17:39:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Measure-to-calculate-total-sales-on-specific-year/m-p/1533494#M30107 HotChilli 2020-12-04T17:39:38Z