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 

 

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