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.           

some_bih's avatar
some_bih
Community Champion
3 years ago

Hi khacwee seems that you use filter filter(salestable,date in both option. This is not best practice as salestable is big table (many rows). Think about changing this part, as we assumy that factor table is very little one compared with salestable.

Hope this help, kudos appreciated.