Forum Discussion

myazigi's avatar
myazigi
Frequent Visitor
7 years ago
Solved

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 fo...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

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's avatar
myazigi
Frequent Visitor
7 years ago

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

All the Kudos to you!!

 

Cheers,

Mauricio