https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Restrict-the-Month-name-with-product-code/m-p/3068767#M106382 <P><SPAN><SPAN><BR /></SPAN></SPAN><img /></P> <P>I need to create matrix table like above,<BR />Here i need to show top n products shipped units on that shipped product how many products returned<BR />so for this i created a rank measure like this&nbsp;&nbsp;<SPAN>Rank Product code By Shipped&nbsp; &amp; Customer return = </SPAN><SPAN>RANKX</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(Dim_Product[Product code]),'_Sales'[Shipped ],, </SPAN><SPAN>DESC</SPAN><SPAN>,Dense)</SPAN><BR /><BR />Here i am restricting filter only in product code , i can't able to restrict in month level at that time it is showing error and both are coming from different tables<BR /><BR /><BR />HJow i can perform this&nbsp;<BR /><BR />Thanks&nbsp;<BR />Allen<BR /><BR /><BR /><BR /></P> Wed, 08 Feb 2023 11:39:06 GMT AlanP514 2023-02-08T11:39:06Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Restrict-the-Month-name-with-product-code/m-p/3068767#M106382 <P><SPAN><SPAN><BR /></SPAN></SPAN><img /></P> <P>I need to create matrix table like above,<BR />Here i need to show top n products shipped units on that shipped product how many products returned<BR />so for this i created a rank measure like this&nbsp;&nbsp;<SPAN>Rank Product code By Shipped&nbsp; &amp; Customer return = </SPAN><SPAN>RANKX</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(Dim_Product[Product code]),'_Sales'[Shipped ],, </SPAN><SPAN>DESC</SPAN><SPAN>,Dense)</SPAN><BR /><BR />Here i am restricting filter only in product code , i can't able to restrict in month level at that time it is showing error and both are coming from different tables<BR /><BR /><BR />HJow i can perform this&nbsp;<BR /><BR />Thanks&nbsp;<BR />Allen<BR /><BR /><BR /><BR /></P> Wed, 08 Feb 2023 11:39:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Restrict-the-Month-name-with-product-code/m-p/3068767#M106382 AlanP514 2023-02-08T11:39:06Z