Forum Discussion

Beno1234's avatar
Beno1234
Frequent Visitor
9 years ago
Solved

STDEV and SUMMARIZE HELP!

  HI, im trying to get the STDev of a sumarized table, I tried the measure in the photo, It gives me the number Im looking for, but I cant display it in the Graph. I need to apply filters o...
  • Beno1234's avatar
    9 years ago

    I found the answer, 

    It only needed a CALCULATE

    STD = calculate(STDEVX.S(SUMMARIZE(Sheet1,Sheet1[FECHA],"VENTAS",sum(Sheet1[VALOR])),[VENTAS]),Sheet1[FECHA])

     

    :smileylol: