topN on a summarised table

[akvjack]

Hi, I'm trying to do a topN on a summarised table, and having trouble telling it what column to apply the TOPN to.

I have the screenshot so far. But I'm clearly missing the column that i want to apply the topn by. But wherever I insert it, it just get errors : (

(I've tested the summarize on its own and it works fine)

any help would be greatly appreciated

[ray_ux · Accepted solution]

@akvjack Needs to remove the additional table from the statement. 

if it doesn't work, worth checking these examples :

ttps://www.sqlbi.com/tv/topn-dax-guide/

https://dax.guide/topn/