top n

[Anonymous]

hi
i am trying to display top 1 place name from place table.
i tried using this formula didnt work

top = TOPN (1,Place,Place[place_name],DESC)

[Anonymous · Accepted solution]

Hi @Anonymous ,

What you are creating is a measure or calculate column, right? Actually, it will return a table with the top N rows of Place table when  you use TOPN function. You can refer the content in the following threads to get the top 1 place name.

Dax Top 1 Name

Display Top 1 customer on Card Visual

If the above ones are not applicable for your scenario, please provide some sample data in Place table (exclude sensitive data) and your expected result with example and backend logic. Thank you.

Best Regards

[Anonymous]

You can't return a whole row from a table into a measure/column. You have to return a scalar value.

[amitchandak]

@Anonymous , this return table not measure

example of usages

Top N = CALCULATE([measure],TOPN(10,all(sheet1[Business_Process_Type]),[measure],DESC),VALUES(sheet1[Business_Process_Type]))

Refer I have discussed this case in my video

https://www.youtube.com/watch?v=QIVEFp-QiOk