Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamic Standard Deviation with an Attributes Slicer

Hey Datanauts,

 

I know there have been a lot of posts on people trying to understand standard deviation within DAX. And I've read many of the posts, but it is still a little perplexing to me. Actually, a lot of perplexing. I want to find standard deviation based upon a dynamic attribute slicer I've created. I get the following:

 

 

My attributes slicer connects to my Bridge table which connects to my FactInvoiceTable below:

 

 

My attributes include: Dim_Organization_Name, Fiscla_Year, Dim_Department_Name. Thus when I choose one of these attributes in my Attributes slicer, it filters down to my FactInvoiceTable and then subsequently find the standard deviation of each individual group within the selected attribute. Any help on this would much be appreciated. 

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support

    Hi Anonymous ,

     

    kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hey. v-frfei-msft I do have confidential information in there. That's why I didn't do it.