Power BI
hace 2 años
Expresion de SWITCH
Hola, creeuna nueva medida usando SWITCH, le adicione al inicio un crssfiltered, para que respete cuando cambio un filtro en el slicer..
cuando selecciono un grupo del flitro funciona perfecto, pero cuando estan selecionados todos me sale un error..
Target Specialty =
IF(ISCROSSFILTERED(DimLocationTransaction[Grouping]),
SWITCH(TRUE(),
VALUES(DimLocationTransaction[Grouping]) = "InnovaCare-OFP", [Target Specialty OFP],
VALUES(DimLocationTransaction[Grouping]) = "Innovacare-FCP", [Target Specialty FCP],
VALUES(DimLocationTransaction[Grouping]) = "InnovaCare-Trinity", [Target Specialty OFP],
VALUES(DimLocationTransaction[Grouping]) = "Innovacare-FL-MSO", [Target Specialty OFP],
VALUES(DimLocationTransaction[Grouping]) = "Innovacare-PAK", [Target Specialty OFP],
VALUES(DimLocationTransaction[Grouping]) = "MSO", [Target Specialty OFP],
VALUES(DimLocationTransaction[Grouping]) = "NULL", [Target Specialty OFP],
VALUES(DimLocationTransaction[Grouping]) = "UNDETERMINED", [Target Specialty OFP],
VALUES(DimLocationTransaction[Grouping]) = "InnovaCare-Corp", [Target Specialty OFP],
[Target Specialty OFP]),
[Target Specialty OFP])
0
1
Respuestas
hace 2 años
0
