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!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hi, I wrote a measure that takes in the values of a category column and use a switch statement to return the appropriate number based on the category. However It only checks if the first statement is true. It will always be true however I would like it to check both conditions and return the results of the two.
the switch is to assign calculated measures to budget and Actual which are values in another table.
Is there a way to achieve this ?
Solved! Go to Solution.
Hi @Sagejah9 !
Please try to combine both conditions using && operator in your switch statement, if both conditions will met, you can assign the appropriate measure calculation.
Regards,
Hasham
Hi @Sagejah9 !
Please try to combine both conditions using && operator in your switch statement, if both conditions will met, you can assign the appropriate measure calculation.
Regards,
Hasham
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 57 | |
| 52 | |
| 40 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 115 | |
| 106 | |
| 41 | |
| 34 | |
| 25 |