Standard Deviation

[myazigi]

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

[v-yulgu-msft · Accepted solution]

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

[myazigi]

Thank you so much Yuliana, it was exactly what I need!!!

All the Kudos to you!!

Cheers,

Mauricio