Forum Discussion

Thulasiraman's avatar
Thulasiraman
Icon for Helper II rankHelper 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
  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    hi Thulasiraman 

    SUMMARIZE returns a table, and, in most cases, a table can't be used as a scalar value directly. So comes the warning.

    You need either make some calculation based on that table or use the code to create a new table.

    • Thulasiraman's avatar
      Thulasiraman
      Icon for Helper II rankHelper II
      3 years ago

      Hi FreemanZ 

       

      Thanks for the explanation.  Can I use this dax in TOPN function?

       

       

      • FreemanZ's avatar
        FreemanZ
        Icon for Super User rankSuper User
        3 years ago

        hi Thulasiraman Yes, as you see in MahyarTF 's code, SUMMARIZE is every commonly used to build intermediate virtual tables for furthe calculation, like TOPN, ADDCOLUMNS, FILTER. Any function taking table expression as argument is good to nest upon SUMMARIZE.