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(AVERAGE('**DM-InvestabilityIndex**'[Value]),ALLEXCEPT('**DM-InvestabilityIndex**','**DM-InvestabilityIndex**'[Type],'**DM-InvestabilityIndex**'[CITY]),AND( '**DM-InvestabilityIndex**'[Year]>=AvgStartYear,'**DM-InvestabilityIndex**'[Year]<=AvgeEdYear))
var SD = CALCULATE(STDEV.S('**DM-InvestabilityIndex**'[Value]),ALLEXCEPT('**DM-InvestabilityIndex**','**DM-InvestabilityIndex**'[Type],'**DM-InvestabilityIndex**'[CITY]),AND('**DM-InvestabilityIndex**'[Year]>=AvgStartYear,'**DM-InvestabilityIndex**'[Year]<=AvgeEdYear))
var ND = NORM.DIST('**DM-InvestabilityIndex**'[Value],Mean,SD,TRUE())*100
return
ND
******
******
I also attach part of the image of my table (<2000 rows) in below:
I have succsssfully use same DAX in another table but fail in this.
Appreciate for your advise. Thanks a lot.
3 Replies
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.
