Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |