Caso SQL en la función DAX 'SWITCH' no admite la comparación de valores de tipo

[Anonymous]

Tengo caso de convento SQL en DAX

está mostrando que el error puede alguien guiar qué error hice

La función 'SWITCH' no admite la comparación de valores de tipo True/False con valores de tipo Text. Considere la posibilidad de utilizar la función VALUE o FORMAT para convertir uno de los valores.

Type = Var _Feature = CONTAINSSTRING(EODWQ[Reporting Segment Quantity],"Feature")

Var _Accessories = CONTAINSSTRING(EODWQ[Reporting Segment Dollars],"Accessory")

Var _VoiceAddALines = CONTAINSSTRING(EODWQ[Product Category],"'Business L3 & More") //|| CONTAINSSTRING(EODWQ[Product Category],"Family L3 & More") || CONTAINSSTRING(EODWQ[Product Category],"No Credit Check L3 & More")

Var _PrepaidActivations = CONTAINSSTRING( EODWQ[Product Category], "'Prepaid Voice") //|| CONTAINSSTRING( EODWQ[Product Category], "'Prepaid Mobile Internet")

Var _Equipment = CONTAINSSTRING( EODWQ[Product Category], "'Inventory : Equipment" )

var _BTSActs =  CONTAINSSTRINGEXACT( EODWQ[Product Category], "'Business") //|| CONTAINSSTRINGEXACT( EODWQ[Product Category], "'Individual / Family") || CONTAINSSTRINGEXACT( EODWQ[Product Category], "'No Credit Check")

Var _Voice_Activations =  CONTAINSSTRINGEXACT( EODWQ[Product Category], "'Business L1/L2") //|| CONTAINSSTRINGEXACT( EODWQ[Product Category], "'Family L1/L2") || CONTAINSSTRINGEXACT( EODWQ[Product Category], "'Individual") || CONTAINSSTRINGEXACT( EODWQ[Product Category], "'No Credit Check L1/L2") 
Var _Upgrade_term_type = CONTAINSSTRING(EODWQ[term type],"Upgrade")

Var _Null_term_type = CONTAINSSTRING(EODWQ[term type],"NULL")

Var _Equipment_term_type = CONTAINSSTRING(EODWQ[term type],"Equipment")

Var _Accessories_term_type = CONTAINSSTRING(EODWQ[term type],"Accessories")

Var _Feature_term_type = CONTAINSSTRING(EODWQ[term type],"Feature")

Var _Activation_term_type = CONTAINSSTRING(EODWQ[term type],"Activation")

Var _SprintMigration_term_type = CONTAINSSTRING(EODWQ[term type],"Sprint Migrations")

Var _PrepaidToPostpaid_term_type = CONTAINSSTRING(EODWQ[term type],"Prepaid to Postpaid")


Return

switch( true(),
	_Upgrade_term_type,
		switch( true(),
			_Feature ,"Features",
			_Accessories, "Accessories",
			_VoiceAddALines, "Upgrades",
			_PrepaidActivations, "Prepaid Activations",
			_Equipment, "Equipment","Upgrades"
			),
    _Activation_term_type,
        switch( true(),
			_Feature ,"Features",
			_Accessories, "Accessories",
			_VoiceAddALines, "Voice Add A Lines",
			_PrepaidActivations, "Prepaid Activations",
            _BTSActs,"BTS Activations",
            _Voice_Activations,"Voice Activations",
			_Equipment, "Equipment","Voice Activations"
			),
    _Equipment_term_type,"Equipment",
        switch( true(),
			_Feature ,"Features",
			_Accessories, "Accessories",
			_VoiceAddALines, "Voice Add A Lines",
			_PrepaidActivations, "Prepaid Activations",
            _BTSActs,"BTS Activations",
            _Voice_Activations,"Voice Activations",
			_Equipment, "Equipment","Equipment"
			),
    _Accessories_term_type,"Accessories",
        switch( true(),
			_Feature ,"Features",
			_Accessories, "Accessories",
			_VoiceAddALines, "Voice Add A Lines",
			_PrepaidActivations, "Prepaid Activations",
            _BTSActs,"BTS Activations",
            _Voice_Activations,"Voice Activations",
			_Equipment, "Equipment","Accessories"
			),
    _Feature_term_type,"Features",
        switch( true(),
			_Feature ,"Features",
			_Accessories, "Accessories",
			_VoiceAddALines, "Voice Add A Lines",
			_PrepaidActivations, "Prepaid Activations",
            _BTSActs,"BTS Activations",
            _Voice_Activations,"Voice Activations",
			_Equipment, "Equipment","Features"
			),
    _Null_term_type,
         switch( true(),
			_Feature ,"Features",
			_Accessories, "Accessories",
			_VoiceAddALines, "Voice Add A Lines",
			_PrepaidActivations, "Prepaid Activations",
            _Voice_Activations,"Voice Activations",
			"Equipment"
			)

)

[parry2k · Accepted solution]

@M_OVAISJANZEB no está seguro acerca de esta parte de la instrucción switch

    _Equipment_term_type,"Equipment",
     
    _Accessories_term_type,"Accessories",