How optimized the switch case for the better performance and make faster

Hi mdaamirkhan ,

Formula Engine (FE) is single-threaded. If the used formulas in your report is too much complex, it will reduce its performance. For how to improve the performance of above measure which wrapped multiple measures within Switch function, please refer to:

Optimizing IF and SWITCH expressions using variables

Optimizing DAX expressions involving multiple measures

Formula engine and storage engine in SSAS

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.