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! Get ahead of the game and start preparing now! Learn more
input table Output table
subcategory Price subcategory Price Output Column
Small 100 Small 100 300
Medium 200 Medium 200 200
Large 300 Large 300 100
I have tried with switch function but not getting output any one please help me out. need to calculate output column using calculate column
@GirishS3 , A new column
Switch(True() ,
[subcategory] = "Small", maxx(filter(Table, [subcategory] = "Large"), [Price]),
[subcategory] = "Large", maxx(filter(Table, [subcategory] = "Small"), [Price]),
[Price]
)
This code is not working getting error like this
The syntax for 'Table' is incorrect. (DAX(Switch(True() ,SELECTEDVALUE('Table'[Sub-Category]) = "Small", maxx(filter(Table, SELECTEDVALUE('Table'[Sub-Category]) = "Large"), 'Table'[Price]),SELECTEDVALUE('Table'[Sub-Cat
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 46 | |
| 42 | |
| 23 | |
| 18 |
| User | Count |
|---|---|
| 192 | |
| 125 | |
| 99 | |
| 67 | |
| 48 |