Forum Discussion

khacwee's avatar
khacwee
Frequent Visitor
3 years ago
Solved

Which ways are more efficient comparing between having a Measure in DAX formula or using VAR?

Dear all,   I have a performance related questions regarding which ways are more efficient and less resources consuming in Power BI for below?   Option 1: Having 3 Measures in total Factor = cal...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi khacwee ,

     

    Regarding your question, both options are valid and efficient. However, the second option is more efficient in terms of performance because it uses only one measure instead of three measures.

     

                                                                                                                                                             

    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.           

sergej_og's avatar
sergej_og
Super User
3 years ago

It seems to me "Option 1" is good to go in this case.
You can use every single measure (once created) over and over again for other purposes in your business logic...maybe tweek a bit better for performance issues.
As some_bih mentioned using FILTER might be not best practice.
Try to avoid if you run into performance issues.

Regards