cancel
Showing results for
Did you mean:
Highlighted
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.

Mauricio

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## 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.

```Average_CumplxActividad = AVERAGE(AZURE[CumplxActividad])

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
Super Contributor

## 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.

```Average_CumplxActividad = AVERAGE(AZURE[CumplxActividad])

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.
Frequent Visitor

## Re: Standard Deviation

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

All the Kudos to you!!

Cheers,

Mauricio

Announcements

#### Community News & Announcements

Get your latest community news and announcements.

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 134 members 1,775 guests
Recent signins: