Forum Discussion

kirbynguyen's avatar
kirbynguyen
Helper II
5 years ago
Solved

Standard Deviation DAX

Hello,   I am trying to calculate standard deviation from my data:   Product Profit Count Total 1 100 5 500 1 200 4 800 1 300 3 900 1 400 1 400 2 100 7 700 ...
Need Help
Show and Tell
  • kirbynguyen's avatar
    kirbynguyen
    5 years ago

    smpa01  Greg_Deckler 

     

    Well, I think I figured it out. Here's the solution:

     
    prodtop = POWER('Table'[Profit] - 'Table'[prodmean], 2) * 'Table'[Count]
    prodtoptotal = CALCULATE(SUM('Table'[prodtop]), ALLEXCEPT('Table', 'Table'[Product]))
    variance = 'Table'[prodtoptotal] / 'Table'[prodcount]
    std = SQRT('Table'[variance])
     
    I think I can consolidate this into fewer columns so I'll work on that. Thanks for the help 😁
smpa01's avatar
smpa01
Community Champion
5 years ago

kirbynguyen  DAX is working as expected

 

once your dataset is like this

  • kirbynguyen's avatar
    kirbynguyen
    Helper II
    5 years ago

    smpa01 

    Well, the dataset was just a sample. I don't want to pivot my data since the counts are very high and there are more filters than just "product". Thanks for the input though!