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