Forum Discussion

theitguy's avatar
theitguy
Helper I
8 years ago
Solved

Calculation on Grouped Values

Hi guys,   I would like to create a measure which calculates the standard derivation of sums from a group-by action.   I have the following table: launch_history_id Date Seconds_Spend Scor...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI theitguy

     

    Try this MEASURE

     

    Measure =
VAR MyColumn =
    SUMMARIZE (
        TableName,
        TableName[Participant_ID],
        "TotalSeconds", SUM ( TableName[Seconds_Spend] )
    )
RETURN
    STDEVX.P ( MyColumn, [TotalSeconds] )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

HI theitguy

 

Try this MEASURE

 

Measure =
VAR MyColumn =
    SUMMARIZE (
        TableName,
        TableName[Participant_ID],
        "TotalSeconds", SUM ( TableName[Seconds_Spend] )
    )
RETURN
    STDEVX.P ( MyColumn, [TotalSeconds] )