topic Filtering - DAX command in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filtering-DAX-command/m-p/2154057#M49692 <P>Hi, what is wrong with this command?&nbsp;</P><DIV><DIV><DIV><DIV><DIV><SPAN>Acer min = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>'Raportcen'</SPAN><SPAN>[min.price]</SPAN><SPAN>,</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>'Raportcen'</SPAN><SPAN>,</SPAN><SPAN>Raportcen[producent]</SPAN><SPAN>=</SPAN><SPAN>"Acer"</SPAN><SPAN>))</SPAN></DIV></DIV></DIV><DIV>&nbsp;</DIV><DIV>I need to find the lowest price for Acer brand. The table as below.&nbsp;</DIV><DIV><img /><P>&nbsp;</P><BR /><P>&nbsp;</P>&nbsp;</DIV></DIV><DIV>&nbsp;</DIV></DIV> Mon, 25 Oct 2021 16:43:54 GMT harry6810 2021-10-25T16:43:54Z Filtering - DAX command https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filtering-DAX-command/m-p/2154057#M49692 <P>Hi, what is wrong with this command?&nbsp;</P><DIV><DIV><DIV><DIV><DIV><SPAN>Acer min = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>'Raportcen'</SPAN><SPAN>[min.price]</SPAN><SPAN>,</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>'Raportcen'</SPAN><SPAN>,</SPAN><SPAN>Raportcen[producent]</SPAN><SPAN>=</SPAN><SPAN>"Acer"</SPAN><SPAN>))</SPAN></DIV></DIV></DIV><DIV>&nbsp;</DIV><DIV>I need to find the lowest price for Acer brand. The table as below.&nbsp;</DIV><DIV><img /><P>&nbsp;</P><BR /><P>&nbsp;</P>&nbsp;</DIV></DIV><DIV>&nbsp;</DIV></DIV> Mon, 25 Oct 2021 16:43:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filtering-DAX-command/m-p/2154057#M49692 harry6810 2021-10-25T16:43:54Z Re: Filtering - DAX command https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filtering-DAX-command/m-p/2154065#M49694 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="291478" data-lia-user-login="harry6810" class="lia-mention lia-mention-user">harry6810</a>&nbsp; you need an aggregator here</P> <P>&nbsp;</P> <P>CALCULATE(<STRONG>MIN/MAX/SUM/AVERAGE(</STRONG>'Raportcen'[min.price]<STRONG>)</STRONG>,FILTER('Raportcen',Raportcen[producent]="Acer"))</P> Mon, 25 Oct 2021 16:42:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filtering-DAX-command/m-p/2154065#M49694 smpa01 2021-10-25T16:42:32Z