topic Re: Direct Query and RANKX in Developer https://community.fabric.microsoft.com/t5/Developer/Direct-Query-and-RANKX/m-p/2274297#M33809 <P><FONT face="tahoma,arial,helvetica,sans-serif">Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="348787" data-lia-user-login="tsmehta" class="lia-mention lia-mention-user">tsmehta</a>,</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">Current power bi has limited most of the Dax function used to create calculated columns or tables if you are working on direct query mode. I'd like to suggest you create a measure expression instead.</FONT><BR /><FONT face="tahoma,arial,helvetica,sans-serif">Regards,</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">Xiaoxin Sheng</FONT></P> Mon, 10 Jan 2022 01:05:58 GMT Anonymous 2022-01-10T01:05:58Z Direct Query and RANKX https://community.fabric.microsoft.com/t5/Developer/Direct-Query-and-RANKX/m-p/2269532#M33781 <P>After trying for a number of times finally was able to use RANKX for direct query data. Do let me know if you are stuck up with this. Happy to help !&nbsp;</P> Thu, 06 Jan 2022 14:01:36 GMT https://community.fabric.microsoft.com/t5/Developer/Direct-Query-and-RANKX/m-p/2269532#M33781 tsmehta 2022-01-06T14:01:36Z Re: Direct Query and RANKX https://community.fabric.microsoft.com/t5/Developer/Direct-Query-and-RANKX/m-p/2274297#M33809 <P><FONT face="tahoma,arial,helvetica,sans-serif">Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="348787" data-lia-user-login="tsmehta" class="lia-mention lia-mention-user">tsmehta</a>,</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">Current power bi has limited most of the Dax function used to create calculated columns or tables if you are working on direct query mode. I'd like to suggest you create a measure expression instead.</FONT><BR /><FONT face="tahoma,arial,helvetica,sans-serif">Regards,</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">Xiaoxin Sheng</FONT></P> Mon, 10 Jan 2022 01:05:58 GMT https://community.fabric.microsoft.com/t5/Developer/Direct-Query-and-RANKX/m-p/2274297#M33809 Anonymous 2022-01-10T01:05:58Z