TOPN function doesn't allow me to quote a table

Question

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 below), Power BI will give me a list of tables, but nothing comes out with topn function here. I also get a warning of syntax error if I try to input table name manually.

Any help will be highly appreciated.

topn = calculate([total kpi], topn(5,'

v-juanli-msft · Answer

Hi&nbsp;Anonymous&nbsp;
As tested, it works on my side.
Measure = CALCULATE(SUM([value]),TOPN(5,Table1,[value]))or Measure = CALCULATE(SUM([value]),TOPN(5,'Table1',[value]))
or
Measure = CALCULATE(SUM([value]),TOPN(5,ALL(Table1),[value]))

Please share a simple data for me to test.
&nbsp;
Best RegardsMaggie
&nbsp;
Community Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Thank you for the prompt feedback. I suspect the issue may relate to my computer language setup or power bi version. Is there a way for me the send you the data and topn function as an attachment rather than a printscreen?

v-juanli-msft · Answer

Hi&nbsp;Anonymous&nbsp;
My pbix
&nbsp;
Best RegardsMaggie
&nbsp;
Community Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Here is the URL to the pbix sampel file.&nbsp;https://app.powerbi.com/groups/me/reports/ac10cde6-be0b-4a8d-9662-242ddc34ceb6?ctid=a1fdea56-3201-4d00-9b76-661338850557&nbsp;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.&nbsp;Thanks!

anonymous · Answer

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.&nbsp;&nbsp;

Forum Discussion

TOPN function doesn't allow me to quote a table

8 Replies

Related content

DATESYTD function

function behavior

DAX Studio space after function name

function enable staging

Rank Function