Forum Discussion
get column based on multiple if conditions
Hello All, Iam working on migration project and have requirment like this: In a table, i want to display different columns based on different conditions in single dax....
MFelix
Super User
Super UserHi Anonymous ,
Try the following code (may need adjustments):
ttt =
SWITCH (
TRUE (),
COUNT ( Table[Direct] ) > 0
&& COUNT ( Table[VP_Director] ) = 0
&& COUNT ( Table[Director_Manager] ) = 0
&& COUNT ( Table[Manager] ) = 0, "VP_Director",
(
COUNT ( Table[Direct] ) > 0
&& COUNT ( Table[DirectVP_Director] ) > 0
&& COUNT ( Table[Director_Manager] ) = 0
&& COUNT ( Table[Manager] ) = 0
)
|| (
COUNT ( Table[VP_Director] ) > 0
&& COUNT ( Table[Direct] ) = 0
&& COUNT ( Table[Director_Manager] ) = 0
&& COUNT ( Table[Manager] ) = 0
), "Director_Manager",
(
COUNT ( Table[Direct] ) > 0
&& COUNT ( Table[VP_Director] ) > 0
&& COUNT ( Table[Director_Manager] ) > 0
&& COUNT ( Table[Manager] ) = 0
)
|| (
COUNT ( Table[VP_Director] ) = 0
&& COUNT ( Table[Direct] ) > 0
&& COUNT ( Table[Director_Manager] ) > 0
&& COUNT ( Table[Manager] ) = 0
)
|| (
COUNT ( Table[VP_Director] ) > 0
&& COUNT ( Table[Direct] ) = 0
&& COUNT ( Table[Director_Manager] ) > 0
&& COUNT ( Table[Manager] ) = 0
), "Manager",
(
COUNT ( Table[Direct] ) > 0
&& COUNT ( Table[VP_Director] ) > 0
&& COUNT ( Table[Director_Manager] ) > 0
&& COUNT ( Table[Manager] ) > 0
)
|| (
COUNT ( Table[VP_Director] ) = 0
&& COUNT ( Table[Direct] ) > 0
&& COUNT ( Table[Director_Manager] ) > 0
&& COUNT ( Table[Manager] ) > 0
)
|| (
COUNT ( Table[VP_Director] ) > 0
&& COUNT ( Table[Direct] ) = 0
&& COUNT ( Table[Director_Manager] ) > 0
&& COUNT ( Table[Manager] ) > 0
)
|| (
COUNT ( Table[VP_Director] ) = 0
&& COUNT ( Table[Direct] ) = 0
&& COUNT ( Table[Director_Manager] ) = 0
&& COUNT ( Table[Manager] ) > 0
), SUBAREA_OWNER
)