Forum Discussion

TechoGirl0's avatar
TechoGirl0
Frequent Visitor
4 years ago
Solved

TOPN 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!   VAR __SomeVariable =      TOP...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi TechoGirl0 ,

     

    If you look at the syntax of TopN ,

    - 502 is the number of rows to return 

    - 1 or 0 is the order to be applied. 0/FALSE/DESC – descending; 1/TRUE/ASC – ascending.

    Syntax = 
TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]…])

     

    Thanks,

    Samarth

     

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, TechoGirl0 

 

Here is the related document, hope it can help you.

https://docs.microsoft.com/dax/topn-function-dax 

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.