Forum Discussion

sathishsam's avatar
sathishsam
Icon for Helper II rankHelper II
2 years ago

Is using Filter inside the Calculate makes any difference?

I have a DAX function written in 2 ways, i see that the 2nd one performs better always, then my question is where should i use the first once   1) Calculate ( SUM(TableA[Col1], TableA[Col2] = "Some...
sathishsam's avatar
sathishsam
Icon for Helper II rankHelper II
2 years ago

Thank you for the reply. How do i write an optimized DAX in this case, the first one usually takes 5 to 6 times more than the second one.