Optimizing DAX

[Anonymous]

Hi All,

I've created the below calculated column and its giving the correct result but somehow my performance is getting impacted as number of records are in 100s Millions,

Is there any better approach to follow here?

Calculation used:

Regards

[ChiragGarg2512]

@Anonymous , Use switch statement in DAX measure,

EBU vs CBU = 
var _v1 = VW_F_ACV[SALES_SEGMENT]
var _v2 = VW_F_ACV[ROLE] = ""
RETURN
    Switch(true(), 
    _v2, 
    Switch(
        true(), 
        OR(OR(_v1 = "Strategic", _v1 = "Enterprise"), _v1 = "Large Corporate"),
        "EBU", 
        OR(OR(_v1 = "Mid Market", _v1 = "Commercial"), _v1 = "Undefined"), 
        "CBU", 
        _v2),
    _v2
    )

 What is needed is to club the scenarios, for example in all of the condition the Role is "" so apply conditons on sales_segment and after that if there are conditions remaining return role itself.

Thank You.

[Anonymous]

Getting the below error while trying to use it

FYI : Both columns (Role and Sales Segment) have same data type.

[ChiragGarg2512 · Accepted solution]

@Anonymous , I have made some changes in the DAX. Use this instead

EBU vs CBU =

var _v1 = VW_F_ACV[SALES_SEGMENT]

var _v2 = VW_F_ACV[ROLE] = ""

RETURN

    Switch(true(),

    _v2,

    Switch(

        true(),

        (_v1 = "Strategic" || _v1 = "Enterprise" || _v1 = "Large Corporate"),

        "EBU",

        (_v1 = "Mid Market"|| _v1 = "Commercial" || _v1 = "Undefined"),

        "CBU",

        VW_F_ACV[ROLE]),

    VW_F_ACV[ROLE]

    )

Thank You.