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 .