Forum Discussion

Thulasiraman's avatar
Thulasiraman
Helper II
3 years ago

Summarize error

Hi   I have created a SUMMARIZE Dax which shows the error which I could not understand.   Pls help Thulasiraman
Need Help
MahyarTF's avatar
MahyarTF
Memorable Member
3 years ago

Hi,

As I know the Summarized measure is a return table and not sure if you use it as a direct measure to calc the sum of column

https://dax.guide/summarize/

  • Thulasiraman's avatar
    Thulasiraman
    Helper II
    3 years ago

    Hi MahyarTF 

     

    I would like to use it in TOPN.  Can you please tell how to write that dax?

    • MahyarTF's avatar
      MahyarTF
      Memorable Member
      3 years ago

      Hi

      This is Dax code for creating the table using Summarize :

      Sheet87Summarize = SUMMARIZE(sheet87, Sheet87[Customer], "sale", sum(Sheet87[Weight]))
      This is TOp N with Summarize :
      Sheet87TopSum = topn(2, SUMMARIZE(sheet87, Sheet87[Customer], "Sales", sum(Sheet87[Weight])))
       

      Appreciate your Kudos and please mark it as a solution if it helps you