https://community.fabric.microsoft.com/t5/Developer/dax-for-lastnonblank-with-filters/m-p/429692#M13080 <P>I am trying to filter the measure count(...) with an expression from Orders table with condition Final=1.I am not able to include that anywere in the measure.Tried a couple of ways but no luck.Ps help</P><P>&nbsp;</P><P>TotalReceiving:=calculate(COUNT('Orders'[OrderID]),LASTNONBLANK('Date'[Date],CALCULATE(COUNT('Orders'OrderID]))))</P><P>I need to include another filter condition here like:</P><P>'Orders'[Final]=1</P> Thu, 31 May 2018 18:49:45 GMT Anonymous 2018-05-31T18:49:45Z https://community.fabric.microsoft.com/t5/Developer/dax-for-lastnonblank-with-filters/m-p/429692#M13080 <P>I am trying to filter the measure count(...) with an expression from Orders table with condition Final=1.I am not able to include that anywere in the measure.Tried a couple of ways but no luck.Ps help</P><P>&nbsp;</P><P>TotalReceiving:=calculate(COUNT('Orders'[OrderID]),LASTNONBLANK('Date'[Date],CALCULATE(COUNT('Orders'OrderID]))))</P><P>I need to include another filter condition here like:</P><P>'Orders'[Final]=1</P> Thu, 31 May 2018 18:49:45 GMT https://community.fabric.microsoft.com/t5/Developer/dax-for-lastnonblank-with-filters/m-p/429692#M13080 Anonymous 2018-05-31T18:49:45Z https://community.fabric.microsoft.com/t5/Developer/dax-for-lastnonblank-with-filters/m-p/430097#M13092 <P>@Anonymous,</P> <P>&nbsp;</P> <P>You may check if the following link helps.</P> <P><A href="https://www.sqlbi.com/articles/filter-arguments-in-calculate/" target="_blank">https://www.sqlbi.com/articles/filter-arguments-in-calculate/</A></P> Fri, 01 Jun 2018 08:45:56 GMT https://community.fabric.microsoft.com/t5/Developer/dax-for-lastnonblank-with-filters/m-p/430097#M13092 v-chuncz-msft 2018-06-01T08:45:56Z