https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Dynamic-Order-For-TopN-Function-in-DAX/m-p/1195366#M3262 <P>I am new to DAX and probably making a noob mistake. I want to change my TopN order to asc or desc order based on whether the selected measure is summing to positive or negative. But so far, I have not been successful with the below code. I am not sure why the DAX is not accepting OrderTopN variable in order definition. I have been able to solve it the long way but I wanted to know why the below code ain't working?</P><P>&nbsp;</P><P>VAR OrderTOPN =IF([ADPR.EM]&gt;=0,1,0)</P><P>&nbsp;</P><P>TopN.ADPR =<BR />CALCULATE (<BR />[ADPR.EM],<BR />TOPN (<BR />'mn-value'[n-value Value],<BR />ALL ( 'mprofile'[Org_Name] ),<BR />[ADPR.EM],OrderTOPN<BR />),<BR />VALUES ( 'mprofile'[Org_Name] )<BR />)</P><P>&nbsp;</P><P>RETURN TopN.ADPR</P> Wed, 01 Jul 2020 14:40:55 GMT Anonymous 2020-07-01T14:40:55Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Dynamic-Order-For-TopN-Function-in-DAX/m-p/1195366#M3262 <P>I am new to DAX and probably making a noob mistake. I want to change my TopN order to asc or desc order based on whether the selected measure is summing to positive or negative. But so far, I have not been successful with the below code. I am not sure why the DAX is not accepting OrderTopN variable in order definition. I have been able to solve it the long way but I wanted to know why the below code ain't working?</P><P>&nbsp;</P><P>VAR OrderTOPN =IF([ADPR.EM]&gt;=0,1,0)</P><P>&nbsp;</P><P>TopN.ADPR =<BR />CALCULATE (<BR />[ADPR.EM],<BR />TOPN (<BR />'mn-value'[n-value Value],<BR />ALL ( 'mprofile'[Org_Name] ),<BR />[ADPR.EM],OrderTOPN<BR />),<BR />VALUES ( 'mprofile'[Org_Name] )<BR />)</P><P>&nbsp;</P><P>RETURN TopN.ADPR</P> Wed, 01 Jul 2020 14:40:55 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Dynamic-Order-For-TopN-Function-in-DAX/m-p/1195366#M3262 Anonymous 2020-07-01T14:40:55Z