Hi Experts,
As per title, below is my code in calculated column:
******
I have succsssfully use same DAX in another table but fail in this.
Appreciate for your advise. Thanks a lot.
Solved! Go to Solution.
HI,
I finally figure out. Normal distribution cannot have 0 standard deviation, which I have for some city, i.e. all vlaue in entire time series was the same. I just add an if function to become 0.00000001 to minimise effect if the result was 0 to SD dax, then it works.
Hi, @TWMY1014 ;
Sorry I can't reproduce your formula, can you share the wrong information tip, or a simple file (after removing sensitive information)?
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-yalanwu-msft,
Thanks for your reply. Seems I can't attach the pbix file here so i screen cap for you. Thanks.
HI,
I finally figure out. Normal distribution cannot have 0 standard deviation, which I have for some city, i.e. all vlaue in entire time series was the same. I just add an if function to become 0.00000001 to minimise effect if the result was 0 to SD dax, then it works.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
119 | |
75 | |
65 | |
51 | |
51 |
User | Count |
---|---|
184 | |
104 | |
82 | |
79 | |
78 |