How to create a calculated column based on some conditions in Power Bi

[lavdeepk]

I am struggling to create a calculated column based on some conditions in Power Bi.  

Refer to the below sample data there are 4 Branch codes against a single Customer. My condition is if a Customer no has this item code "12000" then mark as "Direct Sale " else "Corp Sale " for that Customer all txn .(refer desired results )

Please help me with the DAX formula to achieve desired results.

Customer	Branch Code	Cust Type ((desired results)
CUST-34212	12902	Corp Sale
CUST-34212	12087	Corp Sale
CUST-34212	12921	Corp Sale
CUST-34212	12003	Corp Sale
CUST-687768	12902	Direct Sale
CUST-687768	12000	Direct Sale
CUST-687768	12921	Direct Sale
CUST-687768	12003	Direct Sale
CUST-752061	12902	Direct Sale
CUST-752061	12000	Direct Sale
CUST-752061	12921	Direct Sale
CUST-752061	12003	Direct Sale
CUST/018305	12902	Corp Sale
CUST/018305	12909	Corp Sale
CUST/018305	12921	Corp Sale
CUST/018305	12003	Corp Sale
CUST/018300	12902	Direct Sale
CUST/018300	12000	Direct Sale
CUST/018300	12921	Direct Sale
CUST/018300	12003	Direct Sale

[DataInsights · Accepted solution]

@lavdeepk,

Try this calculated column:

Cust Type = 
VAR vCount =
    CALCULATE (
        COUNT ( Table1[Branch Code] ),
        ALLEXCEPT ( Table1, Table1[Customer] ),
        Table1[Branch Code] = "12000"
    )
VAR vResult =
    IF ( vCount > 0, "Direct Sale", "Corp Sale" )
RETURN
    vResult