Forum Discussion
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...
Sujit_Thakur
Solution Sage
Solution SageDear 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
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.
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
Thanks Anonymous
But I was just trying to help
I am also in learning phase .
Thanks for letting me know about it 😀
- mahoneypat
Microsoft Employee
Keep learning and proposing solutions Sujit_Thakur . We were all there at one point, and optimizing measures can be tough.
Regards,
Pat
