Forum Discussion
TOPN function doesn't allow me to quote a table
Hi, I try to create a topn measure to get the sum of of top 5 KPI achievement %, however, it looks like the TOPN function doesn't allow me to quote a table. Usually after typing the ' sign (see belo...
Hi Anonymous
My pbix
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here is the URL to the pbix sampel file.
I just tried inputting the same measure on a colleagues's power query module (in Excel), which seems to work. I wouldn't like to know why it doesn't work with my power bi desktop.
Thanks!
Hi, just to let you know that I have installed the latest power bi desktop and open your file from there, I got the same error message with your function.
I've had PowerBI act funny becaue of spaces once - try using DAX formatter to format your code, maybe it will help:
