Retrieving a particular column created by using the SUMMARIZE function

[Anonymous]

Good day,

I am using the below formula to create a table, the intention of which is to identify the MAX within the table - Whilst using the Count to check the highest number, what I am actually trying to accomplish is returning the category for which it is the highest.

Test = TOPN({1},SUMMARIZE('Mytable'

, 'MyTable'[Name]

, "Count", COUNT('FACT'[Id])

) )

What I am after is just returning the category in the table created by the Summarize function, however I cannot seem to reference it, and I have considered using a VAR, but I am not sure which function I could use to return the value from it. 

Please assist and Thanks in advance !

Regards,

[v-lili6-msft · Accepted solution]

HI, @Anonymous 

Please add an order conditional in the TOPN formula:

Test = TOPN({1},SUMMARIZE('Mytable'
, 'MyTable'[Name]
, "Count", COUNT('FACT'[Id])
) , [Count] )

BeforeAfter

Best Regards,

Lin