Forum Discussion

anilpoda's avatar
anilpoda
Frequent Visitor
3 years ago
Solved

How do I know which DAX measure is efficient?

If there are multiple ways to create a DAX measure which yields same result, then how would I know which one to use in my Power BI project? For example using below 2 DAX formulas we can get current y...
Need Help
  • Thejeswar's avatar
    Thejeswar
    3 years ago

    anilpoda ,

    At first sight, felt the CYW2 measure would be a little slow seeing the MAX() function in the query while the other one does not have any additional functions rather than the selectedvalue()

     

    Tried that out with DAX studio to understand the performance with very little data. The Below is the output

    CYW

     

    CYW2

    The Performance is very close with a difference of 3 ms. But still CYW2 is faster

Thejeswar's avatar
Thejeswar
Super User
3 years ago

anilpoda ,

At first sight, felt the CYW2 measure would be a little slow seeing the MAX() function in the query while the other one does not have any additional functions rather than the selectedvalue()

 

Tried that out with DAX studio to understand the performance with very little data. The Below is the output

CYW

 

CYW2

The Performance is very close with a difference of 3 ms. But still CYW2 is faster