New Calculated Column with If and Sum

[titanic123]

Hi All, Please help me with the DAX for calculated column in PowerBi :

I am trying to create a new column using below formula from Excel in PowerBi

Denied Access:=IF(SUM(Details[NCC Denied Access]) > 0, SUM(Details[NCC Denied Access]), blank())

Thansk in advance.

[titanic123]

Thanks a lot this worked well.

[wdx223_Daniel · Accepted solution]

if you are create a calculated column in DAX, the code may be

Denied Access=IF(Details[NCC Denied Access] > 0, Details[NCC Denied Access])