Forum Discussion
top n
hi
i am trying to display top 1 place name from place table.
i tried using this formula didnt work
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.
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
3 Replies
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
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.
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
