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 FreemanZ 

 

I nested in topn function but it shows error.  I posted the screenshot above.

Thulasiraman's avatar
Thulasiraman
Helper II
3 years ago

Hi FreemanZ and MahyarTF 

 

In continuation of above, after referring some material I have created the following for TopN which is working fine:

 

Top3 DC =
VAr ranking = VALUES('Itemwise DC All'[Dye Item])
Return
CALCULATE([Total cost], TOPN( 3, ALL('Itemwise DC All'[Dye Item]), [Total cost]), ranking)
 
There is no creation of virtual table through SUMMARIZE but the above dax gives correct result so far for 3 of my tables which I tried.
 
I request you to kindly validate the above dax if it is correct and applicable in all conditions.
 
Once again thanking you very much for your patient help.