Help on DAX conversation from Tableau to PowerBI

[Anonymous]

Hi Team,

Need help on coverting this below from Tableau to Power Query Custom column

if
[APO Location]="(All)" AND [APO Region]!="(All)"
THEN
IFNULL(SUM([Supply Region]),0)
+IFNULL(SUM([Act Production]),0)
+IFNULL(SUM([Act Supply Otherbottler]),0)

ELSE
if
[APO Location]!="(All)" AND [APO Region]="(All)"
THEN
IFNULL(sum([Total Receipts]),0)
+IFNULL(SUM([Act Production]),0)
+IFNULL(SUM([Act Supply Otherbottler]),0)

ELSE
if
[APO Location]!="(All)" AND [APO Region]!="(All)"
THEN
IFNULL(sum([Total Receipts]),0)
+IFNULL(SUM([Act Production]),0)
+IFNULL(SUM([Act Supply Otherbottler]),0)

ELSE
IFNULL(sum([Production]),0)+IFNULL(sum([Supply Otherbottler]),0)
+IFNULL(sum([Substitution Receipt]),0)
+IFNULL(SUM([Act Production]),0)
+IFNULL(SUM([Act Supply Otherbottler]),0)
END
END
END

[amitchandak]

@Anonymous , You can use Switch, if and coalesce

if (<condition>, <True>, false)

coalesce([Column], <when null value>)

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56