Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
5 years ago

Switch with or Measure

Dear all,

 

Below is the measure i am using.

Currently, can you help me to tweak this measure by introducing Or condition within the switch statement?

CorrectedMeasureDonut =
VAR __raw = [Current HC] + [Preboarding Pipeline] + [Additional approved Exp Hire] + [Additional Approved Graduate] - [Exit Pipeline]
VAR X =
SELECTEDVALUE ( GCCvNGCC[GCC/NGCC/Expats_P])
VAR NEP =
VALUES ( GCCvNGCC[GCC/NGCC/Expats_P] )
VAR ExPVal =
SWITCH (
X,
"Expat",[Expat_P Value],
"Expat",[Expat_M Value],
"Expat",[Expat_S Value],
"Expat",[Expat_SM Value],
"Expat",[Expat_S/A Value],
"Expat",[Expat_ED Value],
0
)
VAR ExP =
IF ( "Expat" IN NEP, ExPVal, 0 )
VAR NaPVal =
SWITCH (
X,
"GCC National", [National_P Value],
"GCC National", [National_M Value],
"GCC National", [National_S Value],
"GCC National", [National_SM Value],
"GCC National", [National_S/A Value],
"GCC National", [National_ED Value],
0
)
VAR NaP =
IF ( "GCC National" IN NEP, NaPVal, 0 )
VAR GDPVal =
SWITCH (
X,
"GDS", [GDS_P Value],
"GDS", [GDS_M Value],
"GDS", [GDS_S Value],
"GDS", [GDS_SM Value],
"GDS", [GDS_S/A Value],
"GDS", [GDS_ED Value],
0
)
VAR GDP =
IF ( "GDS" IN NEP, GDPVal, 0 )
VAR TR = __raw + ExP + NaP+GDP
RETURN
TR
 
 
 
Need Help
Show and Tell

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    vjnvinod , for same values you are retuning different measures

     

    Left is all same

    SWITCH (
    X,
    "GDS", [GDS_P Value],
    "GDS", [GDS_M Value],
    "GDS", [GDS_S Value],
    "GDS", [GDS_SM Value],
    "GDS", [GDS_S/A Value],
    "GDS", [GDS_ED Value],
    0
    )

     

     

    Please refer to my video on switch and see if that can help: https://www.youtube.com/watch?v=gelJWktlR80

     

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.