TOPN Question

Question

Hi, I am new to this community and am trying to advance my DAX knowledge for my job. Could someone tell me what the numbers below the columns represent?Thank you!&nbsp;VAR __SomeVariable =&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TOPN(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;502,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;__SomeTable,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Column1],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Column2],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Product'[Column3],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Location'[Column4],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Location'[Column5],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;)

samarth_18 · Accepted Answer

Hi&nbsp;TechoGirl0&nbsp;,
&nbsp;
If you look at the syntax of TopN ,
- 502 is the&nbsp;number of rows to return&nbsp;
- 1 or 0 is the&nbsp;order to be applied. 0/FALSE/DESC – descending; 1/TRUE/ASC – ascending.
Syntax = 
TOPN(&lt;n_value&gt;, &lt;table&gt;, &lt;orderBy_expression&gt;, [&lt;order&gt;[, &lt;orderBy_expression&gt;, [&lt;order&gt;]]…]) 
&nbsp;
Thanks,
Samarth
&nbsp;

Forum Discussion

TOPN Question

2 Replies

Related content

Bookmark questions

TopN

TopN

TOPN Function - Question/Comment

Architecture question and brainstorming