Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

standard deviation for grouped data

Hello    I have a question and appreciate it if you answer.   I have a table in which the data for sales of different products has been stored daily. to elaborate more: each day, the number o...
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Try

Standard dev all time =
VAR summaryTable =
    CALCULATETABLE (
        ADDCOLUMNS (
            SUMMARIZE ( 'Reports sale', 'Reports sale'[Date] ),
            "@sales", CALCULATE ( SUM ( 'Reports sale'[productssold] ) )
        ),
        REMOVEFILTERS ( 'Reports sale'[Date] )
    )
RETURN
    STDEVX.P ( summaryTable, [@sales] )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

hi johnt75, 

 

Thanks for your response .

I tried your solution, But It does not give me the constant number; when I tried to show it on the table, the std value cahnges over time , and when I drill down to day it becomes 0 . 

 

 

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    4 years ago

    Which table is the Month / Day in your table visual coming from ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    from report[date] table .