Hi SivaMani,
In Report Builder, I could switch MDX to DAX, but it will lost the content when transform, so you need to write DAX query manually.
You said that you can't run and edit the report which write with DAX, what error did you get? What is your report builder version(Please note that the ability to use the query designer for DAX is limited to SSAS tabular data sources built in 2016+ only.)? You could refer to Query designer support for DAX now available in Report Builder and SQL Server Data Tools for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi SivaMani,
In Report Builder, I could switch MDX to DAX, but it will lost the content when transform, so you need to write DAX query manually.
You said that you can't run and edit the report which write with DAX, what error did you get? What is your report builder version(Please note that the ability to use the query designer for DAX is limited to SSAS tabular data sources built in 2016+ only.)? You could refer to Query designer support for DAX now available in Report Builder and SQL Server Data Tools for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
