https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-function-error-multiple-columns/m-p/1724506#M35686 <P>Hi,&nbsp;<BR /><BR />I don't know what I'm doing wrong here and I don't understand the error message, please help!<BR /><BR /><img /></P><P>&nbsp;</P><P>thank you in advance,</P><P>&nbsp;</P><P>Guillermo</P> Tue, 16 Mar 2021 08:44:07 GMT GuilleATT 2021-03-16T08:44:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-function-error-multiple-columns/m-p/1724506#M35686 <P>Hi,&nbsp;<BR /><BR />I don't know what I'm doing wrong here and I don't understand the error message, please help!<BR /><BR /><img /></P><P>&nbsp;</P><P>thank you in advance,</P><P>&nbsp;</P><P>Guillermo</P> Tue, 16 Mar 2021 08:44:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-function-error-multiple-columns/m-p/1724506#M35686 GuilleATT 2021-03-16T08:44:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-function-error-multiple-columns/m-p/1724655#M35692 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="254681" data-lia-user-login="GuilleATT" class="lia-mention lia-mention-user">GuilleATT</a> , filter return a table. So if this is a measure this will not work </P> <P>&nbsp;</P> <P>Try a measure like</P> <P>&nbsp;</P> <P>maxx(filter('Calendar', [Year] =year(Today())),[Year])</P> Tue, 16 Mar 2021 09:39:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-function-error-multiple-columns/m-p/1724655#M35692 amitchandak 2021-03-16T09:39:02Z