Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.
Hey. @v-frfei-msft I do have confidential information in there. That's why I didn't do it.
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |