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.
User | Count |
---|---|
141 | |
86 | |
64 | |
60 | |
57 |
User | Count |
---|---|
211 | |
109 | |
89 | |
76 | |
74 |