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 t...
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

     

     

     

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