https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Control-the-number-of-displayed-lines-Using-DAX/m-p/1467511#M27789 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="268234" data-lia-user-login="CHIJK" class="lia-mention lia-mention-user">CHIJK</a>&nbsp;，</P><P>&nbsp;</P><P>&nbsp;What's your DAX code? I think you need to add an index column to your main table. You also need to create a new parameter table at "what if parameter", and then you can use ISFILTER() to create a metric based on this. (<A href="https://d-bi.gitee.io/dax-change-row-displayed/" target="_self">This blog</A> may help you a lot)</P><P>&nbsp;</P><P><EM>(I suggest you provide a screenshot of the front-end report instead of the data table in the model, so that I can give a more specific solution)</EM></P><P>&nbsp;</P><P><EM><STRONG>Mark this post as solution if this helps, thanks!</STRONG></EM></P> Sun, 01 Nov 2020 03:38:50 GMT DavisBI 2020-11-01T03:38:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Control-the-number-of-displayed-lines-Using-DAX/m-p/1467504#M27788 <P>I have a table showing customers and their purchase orders. I hope to have a filter to control the display of the customer’s last N purchase records, I tried to use the ISFILTER() function but I did not achieve the desired effect. any ideas?</P><P>&nbsp;</P><P><img /></P> Sun, 01 Nov 2020 03:28:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Control-the-number-of-displayed-lines-Using-DAX/m-p/1467504#M27788 CHIJK 2020-11-01T03:28:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Control-the-number-of-displayed-lines-Using-DAX/m-p/1467511#M27789 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="268234" data-lia-user-login="CHIJK" class="lia-mention lia-mention-user">CHIJK</a>&nbsp;，</P><P>&nbsp;</P><P>&nbsp;What's your DAX code? I think you need to add an index column to your main table. You also need to create a new parameter table at "what if parameter", and then you can use ISFILTER() to create a metric based on this. (<A href="https://d-bi.gitee.io/dax-change-row-displayed/" target="_self">This blog</A> may help you a lot)</P><P>&nbsp;</P><P><EM>(I suggest you provide a screenshot of the front-end report instead of the data table in the model, so that I can give a more specific solution)</EM></P><P>&nbsp;</P><P><EM><STRONG>Mark this post as solution if this helps, thanks!</STRONG></EM></P> Sun, 01 Nov 2020 03:38:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Control-the-number-of-displayed-lines-Using-DAX/m-p/1467511#M27789 DavisBI 2020-11-01T03:38:50Z