Forum Discussion

alexa_0028's avatar
alexa_0028
Icon for Resolver II rankResolver II
4 years ago
Solved

Performance issue using calculate and SUMX

Hi All, I am having a table visual and I am seeing slow performance while adding the measure "test_acc" and it seems to load very slow. test_acc = var test_1 = calculate('Sales'[Volumes], ...
  • amitchandak's avatar
    4 years ago

    alexa_0028 , try like

     

    test_acc =
    var test_1 = calculate(sum('Sales'[Volumes]), left('Product'[Code],3)="ACC")
    RETURN
    calculate( test_1,'Calendar'[cytd_flag]=1)

     

    or

     

    test_acc =
    var test_1 = calculate(sum('Sales'[Volumes]), filter('Product', left('Product'[Code],3)="ACC"))
    RETURN
    calculate( test_1,filter('Calendar','Calendar'[cytd_flag]=1))

  • alexa_0028's avatar
    4 years ago

    Hi All,

    With some retrying, I figured out the way to optimise. The formula I pasted above indeed worked, I was looking the performance along with old measures therefore it was showing high values.
    Thank you so much amitchandak  for pointing me to right direction.

    test_acc =
    var test_1 = calculate('Sales'[Volumes],KEEPFILTER( left('Product'[Code],3)="ACC") ,KEEPFILTER('Calendar'[cytd_flag]=1))
    RETURN
    test_1