Forum Discussion
Standard Deviation
Hello guys,
I'm been strugling with this Standard Deviation and I can´t get to the result.
The case is this:
I need to calculate the Standard Deviation for the average of the CumplxActividad for all the FechaPrograma. If you look at the excel file (https://filedn.com/ljrPfy2XqKh5W5jBkwrESPH/Copia%20de%20Datos_Oc-Nov-Dic.xlsx) you will see the yellow cell that calculates that number easy.
If you look my PBI file (https://filedn.com/ljrPfy2XqKh5W5jBkwrESPH/HELP%20with%20STDEV.pbix) you will see that almost all the calculations are the same than the excel file, except for the yellow cell. I was trying to create some measures to solve the problem, but I can not get that result.
Could every one give me a hand with this? I will really appreciate it.
Many Thanks in advance.
Mauricio
Hi myazigi ,
As you can see, "Visual level filters" is only applied to its corresponding visual. It doesn't change the result of measure shown in card visual. In your scenario, please add the field you want to filter on into a slicer.
Please refer to these measures:
Average_CumplxActividad = AVERAGE(AZURE[CumplxActividad]) Standard Deviation = STDEVX.P(ALLSELECTED(AZURE[FechaPrograma]),[Average_CumplxActividad])
I have uploaded the .pbix file for your reference.
Best regards,
Yuliana Gu
2 Replies
Hi myazigi ,
As you can see, "Visual level filters" is only applied to its corresponding visual. It doesn't change the result of measure shown in card visual. In your scenario, please add the field you want to filter on into a slicer.
Please refer to these measures:
Average_CumplxActividad = AVERAGE(AZURE[CumplxActividad]) Standard Deviation = STDEVX.P(ALLSELECTED(AZURE[FechaPrograma]),[Average_CumplxActividad])
I have uploaded the .pbix file for your reference.
Best regards,
Yuliana Gu
Thank you so much Yuliana, it was exactly what I need!!!
All the Kudos to you!!
Cheers,
Mauricio
