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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Akhil_1411 , what is usage of VALUES ( 'UCD Data'[Sold_To_Ultimate_DUNS_Desc] )

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

amitchandak , values taking distinct customers column and calulating the %UCD and other metrics.

 

This i am passing because of the other visual cross filtering

 

Other visual has distinct customers with % UCD. Screenshot below