Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, Anonymous ;

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi v-yalanwu-msft,

 

Thanks for your reply. Seems I can't attach the pbix file here so i screen cap for you.  Thanks.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.