Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Daer Community,
I am trying to rank a column based on its count in anothercolumn. But the rankx() function is not available there.
Solved! Go to Solution.
Hi @Anonymous ,
Which connection mode you are using?
RANKX() function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Best Regards,
Jay.
Thank you for your reply. Yes, I am using Direct query connection mode.
Hi @Anonymous ,
Which connection mode you are using?
RANKX() function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Best Regards,
Jay.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
23 | |
17 | |
11 | |
11 | |
10 |
User | Count |
---|---|
32 | |
25 | |
15 | |
13 | |
13 |