Forum Discussion

nimp_kp's avatar
nimp_kp
Frequent Visitor
6 years ago

Optimizing measure

Hi   I have made the following measure, used in a matrix, that gives me the correct data. But because of the massive amount of data in the dataset, it takes several minutes to display the data and...
DAX
if statement
Measures
Sujit_Thakur's avatar
Sujit_Thakur
Icon for Solution Sage rankSolution Sage
6 years ago

Dear nimp_kp 

 

Use this and try maybe it could help 


Measure =
Var A = Measure 1
Var B = Measure 2
Var C = Measure 3
Var D = Measure 4
var E = Measure 5
Var test = IF(
HASONEVALUE(Table_1[Column_1]) && A= 0.5 && B-C >=0 && D=1 && CALCULATE(DISTINCTCOUNT(Table_2[Column_1]), Table_2[Column_2] = "Y") >= 1
,
E
)
Return test

 

 

 

Let me know if this helped .

 

Give kudos to motivate ! 

And if it helped please accept as solution .

 

Regards 

Thakur Sujit 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Hi Sujit_Thakur

    Your version is even worse than the original. You should *not* calculate measures before IF unless you know ALL OF THEM will certainly be used later. This is not the case here. In other words, you're suggesting the opposite of optimization.
    • Sujit_Thakur's avatar
      Sujit_Thakur
      Icon for Solution Sage rankSolution Sage
      6 years ago

      Thanks Anonymous  

      But I was just trying to help 

      I am also in learning phase .

      Thanks for letting me know about it 😀

       

      • mahoneypat's avatar
        mahoneypat
        Icon for Microsoft Employee rankMicrosoft Employee
        6 years ago

        Keep learning and proposing solutions Sujit_Thakur .  We were all there at one point, and optimizing measures can be tough.

         

        Regards,

        Pat