Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |