Forum Discussion

Akhil_1411's avatar
Akhil_1411
Icon for Helper IV rankHelper IV
6 years ago

Dax Optimization

Hi,   It is taking 5 mins to visual cross filter with others. I would like to know how i can optimize this dax code to perform better or anyother alternative.   Time taken:-           ...
General Comment
Need Help
Show and Tell
Tips and Tricks
Akhil_1411's avatar
Akhil_1411
Icon for Helper IV rankHelper IV
6 years ago

tex628 ,

 

I have tried your logic. It is not happening. After applying the cross filtering is not happening.😐

 

Thanks,

Akhil.

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
6 years ago

What are the individual load times of these three measures? 

[Dynamic Segment DP DDD]
[Dynamic Segment % UCD]
[Measure Selection Rolling 3 Months Avg]

  • Akhil_1411's avatar
    Akhil_1411
    Icon for Helper IV rankHelper IV
    6 years ago

    tex628 ,

     

    Screenshot below for individual load time.

     

    DAX 01 and 02Dax 03

    • tex628's avatar
      tex628
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Hmm, for me this is a bit too hard to solve without being able to write my own code. I'm assuming the data is confidential? 

      / J