cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Checkers111
Helper III
Helper III

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()
)

1 ACCEPTED SOLUTION
keshavagrawal27
Resolver I
Resolver I

Hello @Checkers111,

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

View solution in original post

1 REPLY 1
keshavagrawal27
Resolver I
Resolver I

Hello @Checkers111,

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

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.