https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-help-in-sum-basis-filter/m-p/2112294#M3958 <P>Hi Team,</P><P>&nbsp;</P><P>I would need your support in getting the solution for one of my query.</P><P>&nbsp;</P><P>From below tabel i need the sum of total unit only for year 2021.</P><P>&nbsp;</P><P>Need&nbsp;<img /></P> Sun, 03 Oct 2021 08:34:19 GMT Anonymous 2021-10-03T08:34:19Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-help-in-sum-basis-filter/m-p/2112294#M3958 <P>Hi Team,</P><P>&nbsp;</P><P>I would need your support in getting the solution for one of my query.</P><P>&nbsp;</P><P>From below tabel i need the sum of total unit only for year 2021.</P><P>&nbsp;</P><P>Need&nbsp;<img /></P> Sun, 03 Oct 2021 08:34:19 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-help-in-sum-basis-filter/m-p/2112294#M3958 Anonymous 2021-10-03T08:34:19Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-help-in-sum-basis-filter/m-p/2112343#M3959 <P>Anonymous</LI-USER>&nbsp;<BR /><BR />Create a new Measure as follows:<BR /><BR />Total 2021 Units = Calculate ( SUM( TableName[Unit]) , TableName[Year] = 2021 )<BR /><BR /></P> Sun, 03 Oct 2021 09:44:30 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-help-in-sum-basis-filter/m-p/2112343#M3959 Fowmy 2021-10-03T09:44:30Z