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.           

Anonymous's avatar
Anonymous
Not applicable
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.