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
Thulasiraman's avatar
Thulasiraman
Icon for Helper II rankHelper 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
Icon for Super User rankSuper 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?