Forum Discussion

vincentakatoh's avatar
vincentakatoh
Helper IV
8 years ago
Solved

Summarize DAX

Hi,  Trying to create a new measure, TotalCount_Sum=39+2= 41.    Me a DAX dummy, can advise what is wrong with below DAX? TotalCount_Sum = SUMMARIZE(data2 ,Data2[3Station] ,Data2[TotalCount],su...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi vincentakatoh,

     

    SUMMARIZE function will return a table as the result, it is impossible to store these result in calculated column or measure.

    You need to summary these records and return the result.

     

    For example:

    TotalCount_Sum =
SUMX (
    SUMMARIZE (
        Data2,
        Data2[3Station],
        Data2[TotalCount],
        "TotalCount", SUM ( Data2[FailCount] )
    ),
    [TotalCount]
)

     

    Reference:

    SUMMARIZE Function (DAX)

    Returns a summary table for the requested totals over a set of groups.

     

    Notice: if your data contains any privacy data, please do mask sensitive data before sharing.

     

    Regards,

    Xiaoxin Sheng

vincentakatoh's avatar
vincentakatoh
Helper IV
8 years ago

Hi Greg_Deckler

Can provide example, tried below but no success? Do I need to add as a Column or Measure?

 

 

TotalCount_Sum = SUMMARIZE(data2
	,Data2[3Station]
	,Data2[TotalCount]
,"TotalCount", sum(Data2[FailCount])
)

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

I have this working for me:

 

Table = SUMMARIZE(Cars,Cars[Asset],Cars[Damage],"Sum",SUM(Cars[Column]))

Obviously different data set, but same thing.