cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
myazigi Frequent Visitor
Frequent Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Standard Deviation

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])

1.PNG2.PNG

 

I have uploaded the .pbix file for your reference.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Standard Deviation

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])

1.PNG2.PNG

 

I have uploaded the .pbix file for your reference.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
myazigi Frequent Visitor
Frequent Visitor

Re: Standard Deviation

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

All the Kudos to you!!

 

Cheers,

Mauricio