https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-the-same-metric-by-top-n-and-top-bottom/m-p/954805#M10888 <P>Hello,&nbsp;</P><P>&nbsp;</P><P><img /></P><P>I did the top n and top bottom filters with DAX (RANX) as other tips explain. Currently i have both metrics (sales units top and sales units bottom) with the same values but one is to be able to filter by Top n and the other by Top Bottom.</P><P>&nbsp;</P><P>Is there any way with DAX to join these two columns in only one being able to be filtered by top N and Top Bottom filters at the same time?</P><P>&nbsp;</P><P>Thank You!</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> Mon, 02 Mar 2020 07:49:55 GMT Anonymous 2020-03-02T07:49:55Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-the-same-metric-by-top-n-and-top-bottom/m-p/954805#M10888 <P>Hello,&nbsp;</P><P>&nbsp;</P><P><img /></P><P>I did the top n and top bottom filters with DAX (RANX) as other tips explain. Currently i have both metrics (sales units top and sales units bottom) with the same values but one is to be able to filter by Top n and the other by Top Bottom.</P><P>&nbsp;</P><P>Is there any way with DAX to join these two columns in only one being able to be filtered by top N and Top Bottom filters at the same time?</P><P>&nbsp;</P><P>Thank You!</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> Mon, 02 Mar 2020 07:49:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-the-same-metric-by-top-n-and-top-bottom/m-p/954805#M10888 Anonymous 2020-03-02T07:49:55Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-the-same-metric-by-top-n-and-top-bottom/m-p/955594#M10940 Create a measure/calculated column:<BR />TopAndBottomRank = <BR />min( [RankTop], [RankBottom] ) Mon, 02 Mar 2020 16:46:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-the-same-metric-by-top-n-and-top-bottom/m-p/955594#M10940 Anonymous 2020-03-02T16:46:31Z