Forum Discussion
Distribution Chart
Hey, @Nico_Branuelo
It's a pleasure to answer for you.
You can check the following link to create a distribution chart using thse functions.
https://docs.microsoft.com/en-us/dax/norm-dist-dax
https://docs.microsoft.com/en-us/dax/stdev-s-function-dax
https://docs.microsoft.com/en-us/dax/averagex-function-dax
Here is an example file. I hope it helps.
If you do not solve your problem, please feel free to ask me.
Best regards
Janey Guo
If this post helps,then consider Accepting it as the solution to help other members find it faster.
Hello v-janeyg-msft ,
Thank you for this. I see that your file has a better and easier way of calculating the Normal Distribution.
The thing that confuses me is that when should I use the Normal Distribution :
- When there are only few data available like on the sample that I gave?
- Is it also applicable on around 2k data? (this is the one that I am working on)
Sorry if this is not clear, I am helping on a project which we are unable to tell if we should follow the normal distribution formula.
Edit : On your file with the formula of Normal Distribution, may I know why did you multiply it by 1000?
Many Thanks!
Hi, Anonymous
I'm not clear what your data looks like.In my opinion,You need to have a set of data and calculate their average and variance to get a normal distribution graph,then you can predict the location and probability of the data.
The more data, the more accurate the result should be.As for the other, I don't know much and sorry I am just a PBI technical engineer.Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.