https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rankx-Filtering/m-p/991248#M12317 <P>Hi, I'm trying to create a "top 10" dashboard for the top 10 customer calls to a help desk. In order to identify the top 10 callers, I have created a RANKX measure as follows:&nbsp;</P><DIV><DIV><SPAN>Company Rank = RANKX(ALL('Top 10 - Q1'[Company Name]),[Call Count],,DESC)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>This seems to work fine for me as the top 10 callers are being identified.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>However, I want to add this measure as a filter to my visuals. For example, what top 5 services are my top 10 customers calling for. I have already used a 'Top N' filter on this visual for 'Top 5 Services'. Since I cannot add two 'Top N' filters to a visual, I thought doing a 'less than or equal to' on a RANKX measure would work but for some reason the filter does not work for me. Is there a way to work around this?&nbsp;</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV> Wed, 25 Mar 2020 15:01:07 GMT sanabritto 2020-03-25T15:01:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rankx-Filtering/m-p/991248#M12317 <P>Hi, I'm trying to create a "top 10" dashboard for the top 10 customer calls to a help desk. In order to identify the top 10 callers, I have created a RANKX measure as follows:&nbsp;</P><DIV><DIV><SPAN>Company Rank = RANKX(ALL('Top 10 - Q1'[Company Name]),[Call Count],,DESC)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>This seems to work fine for me as the top 10 callers are being identified.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>However, I want to add this measure as a filter to my visuals. For example, what top 5 services are my top 10 customers calling for. I have already used a 'Top N' filter on this visual for 'Top 5 Services'. Since I cannot add two 'Top N' filters to a visual, I thought doing a 'less than or equal to' on a RANKX measure would work but for some reason the filter does not work for me. Is there a way to work around this?&nbsp;</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV> Wed, 25 Mar 2020 15:01:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rankx-Filtering/m-p/991248#M12317 sanabritto 2020-03-25T15:01:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rankx-Filtering/m-p/1043161#M14018 <P>Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).</P> <TABLE border="0" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD>Column1</TD> <TD>Column2</TD> </TR> <TR> <TD>A</TD> <TD>1</TD> </TR> <TR> <TD>B</TD> <TD>2.5</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> Thu, 23 Apr 2020 04:49:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rankx-Filtering/m-p/1043161#M14018 Stachu 2020-04-23T04:49:23Z