Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful 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 = [Curr...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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.