locked
DAX Median and Standard Deviation calculations across data set RRS feed

  • Question

  • Hello

    I’ve got the following data set and the 2 measures blow the data set ...

     

    The first measure  [Total_Success] calculates the number of Successes and the second [Average_Success] calculates the average Monthly success…

       [Total_Success]=CALCULATE (

          DISTINCTCOUNT(StudentExam[StudentID]),

            FILTER (

                StudentExam,

                StudentExam[Months_Since_SignUp] >= 3

                    && ( ( StudentExam[StudentStatus] = "Passed" )

                     )       )

    [Average_Success]=[Total_Success] / DISTINCTCOUNT ( StudentExam[SignUp+6M]  )

    My question is, how do I calculate the Median and Standard Deviation values by month across the data set. I've tried it various different ways using MedianX  but can't seem to get it to work correctly ....

    Any suggestion much appreciated

    Ron

     


    Tuesday, October 29, 2019 9:48 PM