https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calucate-sum-with-filter/m-p/1713869#M35367 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="175064" data-lia-user-login="ChoiJunghoon" class="lia-mention lia-mention-user">ChoiJunghoon</a> , Try a measure like</P> <P>&nbsp;</P> <P>if(max(Table[Date])&lt;='2021-3-8', sum(Table[Value])+0, blank())</P> Wed, 10 Mar 2021 12:07:05 GMT amitchandak 2021-03-10T12:07:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calucate-sum-with-filter/m-p/1713264#M35352 <P>Hello. I am facing the little problem.&nbsp;<BR />Could you save me ?&nbsp;<BR /><BR /></P><P>Table&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>value</TD></TR><TR><TD>2021-3-1</TD><TD>1</TD></TR><TR><TD>2021-3-1</TD><TD>10</TD></TR><TR><TD>2021-3-3</TD><TD>2</TD></TR><TR><TD><P>2021-3-5</P></TD><TD>null</TD></TR><TR><TD>2021-3-6</TD><TD><P>2</P></TD></TR><TR><TD>2021-3-8</TD><TD>null</TD></TR><TR><TD>2021-3-10</TD><TD>10</TD></TR><TR><TD>2021-3-11</TD><TD>20</TD></TR><TR><TD>2021-3-11</TD><TD>30</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Create Table inVisualization</P><P>I want to create measure..&nbsp;</P><P>Table[Data] &lt;= 2021-3-8 is 0&nbsp;</P><P>Table[Data] &gt; 2021-3-8 is null&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>Measure</TD></TR><TR><TD>2021-3-1</TD><TD>11</TD></TR><TR><TD>2021-3-3</TD><TD>2</TD></TR><TR><TD><P>2021-3-5</P></TD><TD>0</TD></TR><TR><TD>2021-3-6</TD><TD><P>2</P></TD></TR><TR><TD>2021-3-8</TD><TD>0</TD></TR><TR><TD>2021-3-10</TD><TD>&nbsp;</TD></TR><TR><TD>2021-3-11</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Measure=</P><DIV><DIV><SPAN>&nbsp;Var x1= SELECTEDVALUE(Table[Date])</SPAN></DIV><DIV><SPAN>&nbsp;Var x2= IF (x1&lt;='2021-3-8,0,BLANK())</SPAN></DIV><DIV><SPAN><BR />&nbsp;RETURN</SPAN></DIV><DIV><SPAN>CALCULATE(</SPAN></DIV><DIV><SPAN>sum(Table[Value]),</SPAN></DIV><DIV><SPAN>FILTER(</SPAN></DIV><DIV><SPAN>Table,Table[Date]&lt;='2021-3-8'</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>)<BR /><BR />Could you help me...&nbsp;</SPAN></DIV></DIV> Wed, 10 Mar 2021 09:35:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calucate-sum-with-filter/m-p/1713264#M35352 ChoiJunghoon 2021-03-10T09:35:26Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calucate-sum-with-filter/m-p/1713869#M35367 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="175064" data-lia-user-login="ChoiJunghoon" class="lia-mention lia-mention-user">ChoiJunghoon</a> , Try a measure like</P> <P>&nbsp;</P> <P>if(max(Table[Date])&lt;='2021-3-8', sum(Table[Value])+0, blank())</P> Wed, 10 Mar 2021 12:07:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calucate-sum-with-filter/m-p/1713869#M35367 amitchandak 2021-03-10T12:07:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calucate-sum-with-filter/m-p/1713944#M35371 <P>Thank you !!!</P> Wed, 10 Mar 2021 12:39:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calucate-sum-with-filter/m-p/1713944#M35371 ChoiJunghoon 2021-03-10T12:39:48Z