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
Thulasiraman's avatar
Thulasiraman
Helper II
3 years ago

Hi MahyarTF 

 

Created the above TOPN dax.  

Tested the Summarize portion and it creates a valid table.

But when nested in TOPN it shows the error.

Appreciate very much if you could be able to find the error I am committing.

FreemanZ's avatar
FreemanZ
Super User
3 years ago

Same issue: TOPN returns a list/table. When creating a measure, the outmost function shall be someone returning a value (or a one-row-one-column table), like SUM, MIN/MAX/AVERAGE, COUNTROWS, MINX/MAXX, etc.

try like:

measure = CALCULATE( SUM[tbl[Value]], TOPN(...))

 

What is your ultimate goal of this measure?

  • Thulasiraman's avatar
    Thulasiraman
    Helper II
    3 years ago

    Hi FreemanZ

    Thanks for your continued support and clarifications.

     

    I have successfully created a table using the summarize function.  

     

    Sum Table = SUMMARIZE('Itemwise DC All', 'Itemwise DC All'[Dye Item], "cost", SUM('Itemwise DC All'[Tally amt]))
     
    Now this table contains 2 columns 1) the name of the item (dye item) and 2) the amount (tally amt) column called 'cost'
     
    I want to find the Top N of the above item based on the cost.
     
    I tried using the calculate function as below which is not giving the desired result:
     
    TOPN = CALCULATE(SUM(sum table[cost]), TOPN(3, sum table, SUM(sum table[cost])
     
    It gives the total values against all the items.
     
    Once again thanks for your patient explanations.