Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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()
)
Solved! Go to Solution.
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
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
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 51 | |
| 41 | |
| 32 | |
| 26 | |
| 24 |
| User | Count |
|---|---|
| 131 | |
| 118 | |
| 57 | |
| 45 | |
| 43 |