Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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
| User | Count |
|---|---|
| 52 | |
| 35 | |
| 22 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 57 | |
| 39 | |
| 21 | |
| 21 |