Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Retrieving a particular column created by using the SUMMARIZE function

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,
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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

     

     

     

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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