Forum Discussion
Error when create calculated column (Norm.Dist) in Power BI
Hi Experts, As per title, below is my code in calculated column: ****** Normalized = var AvgStartYear = MIN('**DM-InvestabilityIndex**'[Year]) var AvgeEdYear = 2022 var Mean = CALCULATE(AV...
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 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.