Forum Discussion

jatneerjat's avatar
jatneerjat
Helper V
7 years ago

Dax filter() performance

Hi, Greg_Deckler Anonymous Stachu Could i replace below FILTER() function with some other function to improve performance     CALCULATE(DISTINCTCOUNT(vwFact[AppId]) ,FILTER(vwFact,vwFact[Area]=...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi jatneerjat,

 

Can you post a dummy sample? AND the goals of each formula. For example, we add ALL to clear the context for a purpose. So we can't remove it directly unless it's necessary. 

 

 

Best Regards,
Dale

jatneerjat's avatar
jatneerjat
Helper V
7 years ago

Hi v-jiascu-msft

 

I was not able to attach excel here in forum so adding the image for sample data.

this is for the first dax query.

 

 

Thanks

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi jatneerjat,

     

    It seems the UIDs are unique. So the average could always be 1. What's the expected result of Query 1?

     

     

    Best Regards,
    Dale