Forum Discussion
Switch Measure error
Hi Experts
Cannot see my error in the following switch Measure - Has the siwitch function been composed correctly???
Measure_Switch =
If(Hasonevalue(Table[Type]),
Switch(Selectedvalue(Table[Type]),
"Under 18",[Under_18],
"18+",([18+] + [52+] + [64+] + [70+] + [78+] + [90+] + [104]),
"52+",([52+] + [64+] + [70+] + [78+] + [90+] + [104]),
"64+",([64+] + [70+] + [78+] + [90+] + [104]),
"70+",([70+] + [78+] + [90+] + [104]),
"78+",([78+] + [90+] + [104]),
"90+",([90+] + [104]),
"104+",([104]),
"Clock Stop",[Clock_Stops],
Blank()
)
Hello Anonymous,
We cannot add measures like you did in switch.
Please create variables to do the addition and then use thode variables in switch.
Please mark it as solution if it helped you.
Regards,
Keshav Agrawal
1 Reply
Hello Anonymous,
We cannot add measures like you did in switch.
Please create variables to do the addition and then use thode variables in switch.
Please mark it as solution if it helped you.
Regards,
Keshav Agrawal